summaryrefslogtreecommitdiff
path: root/ext/pgsql/tests
diff options
context:
space:
mode:
authorIlia Alshanetsky <iliaa@php.net>2007-10-03 23:30:46 +0000
committerIlia Alshanetsky <iliaa@php.net>2007-10-03 23:30:46 +0000
commitf6b761b0ac061fd503c5c7caa663a9c9f8fd472a (patch)
treead0741bfc62ff1f90ffe26cf4caadf570dc26c5f /ext/pgsql/tests
parent2448b05b4f17b0a2516f96c17cef412a7f6a30f5 (diff)
downloadphp-git-f6b761b0ac061fd503c5c7caa663a9c9f8fd472a.tar.gz
Fixed bug #42783 (pg_insert() does not accept an empty list for insertion)
Diffstat (limited to 'ext/pgsql/tests')
-rw-r--r--ext/pgsql/tests/80_bug42783.phpt34
1 files changed, 34 insertions, 0 deletions
diff --git a/ext/pgsql/tests/80_bug42783.phpt b/ext/pgsql/tests/80_bug42783.phpt
new file mode 100644
index 0000000000..575e527db9
--- /dev/null
+++ b/ext/pgsql/tests/80_bug42783.phpt
@@ -0,0 +1,34 @@
+--TEST--
+Bug #42783 (pg_insert() does not support an empty value array)
+--SKIPIF--
+<?php
+require_once('skipif.inc');
+?>
+--FILE--
+<?php
+
+require_once('config.inc');
+
+$dbh = @pg_connect($conn_str);
+if (!$dbh) {
+ die ("Could not connect to the server");
+}
+
+pg_query("CREATE TABLE php_test (id SERIAL PRIMARY KEY, time TIMESTAMP NOT NULL DEFAULT now())");
+
+pg_insert($dbh, 'php_test', array());
+
+var_dump(pg_fetch_assoc(pg_query("SELECT * FROM php_test")));
+
+pg_query($dbh, "DROP TABLE php_test");
+pg_close($dbh);
+?>
+===DONE===
+--EXPECTF--
+array(2) {
+ ["id"]=>
+ string(%d) "%d"
+ ["time"]=>
+ string(%d) "%s"
+}
+===DONE===