X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fext-pq;a=blobdiff_plain;f=tests%2Fgh-issue047_jsonb.phpt;fp=tests%2Fgh-issue047_jsonb.phpt;h=1f049d495d71d8e2c00fa3f47b9b81780f2ad45e;hp=0000000000000000000000000000000000000000;hb=9ff77f91387b319a8acc6ba2e4e625df983a07f3;hpb=50d036f2061d397ef6d2f0731ae5613190634c90

diff --git a/tests/gh-issue047_jsonb.phpt b/tests/gh-issue047_jsonb.phpt
new file mode 100644
index 0000000..1f049d4
--- /dev/null
+++ b/tests/gh-issue047_jsonb.phpt
@@ -0,0 +1,40 @@
+--TEST--
+json conv broken since 2.2.1
+--SKIPIF--
+<?php
+include "_skipif.inc";
+?>
+--INI--
+date.timezone=UTC
+--FILE--
+<?php
+echo "Test\n";
+
+include "_setup.inc";
+
+$c = new pq\Connection(PQ_DSN);
+$c->defaultFetchType = \pq\Result::FETCH_ASSOC;
+
+$q = <<<EOF
+    SELECT '0'::jsonb UNION SELECT '"text"'::jsonb;
+EOF;
+$r = $c->exec($q);
+
+var_dump($r->fetchAll());
+?>
+===DONE===
+--EXPECT--
+Test
+array(2) {
+  [0]=>
+  array(1) {
+    ["jsonb"]=>
+    string(4) "text"
+  }
+  [1]=>
+  array(1) {
+    ["jsonb"]=>
+    int(0)
+  }
+}
+===DONE===