BugReport reproductible: sqlite and multiple queries (PHP5.0.0RC1)

php.internals

Unnamed Person

22 years ago
Hi, sorry but bugs.php.net seems unreachable. Here is the reproductible problem I got, related to multiple queries in a single sqlite_query call : <?PHP $query = "create table test1 (id integer primary key, name text); create table test2 (id integer primary key, name text); "; /* Works, creates tables 'test1' and 'test2' */ $db = sqlite_open('test.sqlite'); sqlite_query($db,$query); /* Only creates table 'test1' */ $db2 = sqlite_open('test2.sqlite'); $ok = sqlite_query($db2,$query); ?> I'm using PHP5.0.0RC1 but the bug is still present in PHP5.0.0RC2RC1 from http://snaps.php.net/~andi/. Note this functionnality is needed to make transactionnal queries. Mickael

Wez Furlong

22 years ago
I noticed this problem the other day; it's related to the VM query implementation in libsqlite. --Wez. ----- Original Message ----- From: <mickael.bailly@free.fr> To: <internals@lists.php.net> Sent: Thursday, April 15, 2004 2:15 PM Subject: [PHP-DEV] BugReport reproductible: sqlite and multiple queries (PHP5.0.0RC1)