From 2cef4c3470a09fc2e32a36247c130d9855672284 Mon Sep 17 00:00:00 2001
From: Marcus Boerger <helly@php.net>
Date: Thu, 1 May 2003 13:18:56 +0000
Subject: [PATCH] Check returned associative indexes

---
 ext/sqlite/tests/sqlite_011.phpt | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100755 ext/sqlite/tests/sqlite_011.phpt

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"
+}
-- 
2.40.0