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
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)
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