Check returned associative indexes

1 files changed, 27 insertions, 0 deletions

diff --git a/ext/sqlite/tests/sqlite_011.phpt b/ext/sqlite/tests/sqlite_011.phpt
new file mode 100755
index 0000000000..1aa6704249
--- /dev/null
+++ b/ext/sqlite/tests/sqlite_011.phpt
@@ -0,0 +1,27 @@
+--TEST--
+sqlite: returned associative column names
+--INI--
+sqlite.assoc_case=0
+--SKIPIF--
+<?php
+if (!extension_loaded("sqlite")) print "skip"; ?>
+--FILE--
+<?php 
+include "blankdb.inc";
+
+sqlite_query("CREATE TABLE foo (c1 char, c2 char, c3 char)", $db);
+sqlite_query("CREATE TABLE bar (c1 char, c2 char, c3 char)", $db);
+sqlite_query("INSERT INTO foo VALUES ('1', '2', '3')", $db);
+sqlite_query("INSERT INTO bar VALUES ('4', '5', '6')", $db);
+$r = sqlite_query("SELECT * from foo, bar", $db, SQLITE_ASSOC);
+var_dump(sqlite_fetch_array($r));
+?>
+--EXPECT--
+array(3) {
+  ["c1"]=>
+  string(1) "4"
+  ["c2"]=>
+  string(1) "5"
+  ["c3"]=>
+  string(1) "6"
+}