I noticed this problem the other day; it's related to the VM query implementation in libsqlite.
--Wez. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 15, 2004 2:15 PM Subject: [PHP-DEV] BugReport reproductible: sqlite and multiple queries (PHP5.0.0RC1) > > 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 > > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php