X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fext-pq;a=blobdiff_plain;f=tests%2Fcursor001.phpt;h=f4493f09c8f5d7f6057eca575a0bb6b007728363;hp=1e912b5552274cb8929f76b60e1003ec2f20f73a;hb=d662d7beb20a15ca8ca95761543f6b9d3b6bff29;hpb=19011ee23e5bdb9a46778e190a61e4ce6c765be7

diff --git a/tests/cursor001.phpt b/tests/cursor001.phpt
index 1e912b5..f4493f0 100644
--- a/tests/cursor001.phpt
+++ b/tests/cursor001.phpt
@@ -19,6 +19,22 @@ for ($r = $p->fetch(2); $r->numRows; $p->move(1), $r = $p->fetch(2)) {
 		echo "\n";
 	}
 }
+try {
+	$p = new pq\Cursor($c, "mycursor", pq\Cursor::WITH_HOLD,
+		"SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
+} catch (Exception $ex) {
+	$p->close();
+}
+$p = new pq\Cursor($c, "mycursor", pq\Cursor::WITH_HOLD,
+	"SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
+for ($r = $p->fetch(2); $r->numRows; $p->move(1), $r = $p->fetch(2)) {
+	foreach ($r as $row) {
+		foreach ($row as $col) {
+			echo "	$col";
+		}
+		echo "\n";
+	}
+}
 ?>
 ===DONE===
 --EXPECT--
@@ -33,4 +49,14 @@ Test
 	20
 	24
 	26
+	0
+	2
+	6
+	8
+	12
+	14
+	18
+	20
+	24
+	26
 ===DONE===