Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:9183
Return-Path: <mickael.bailly@free.fr>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 91788 invoked by uid 1010); 15 Apr 2004 13:15:06 -0000
Delivered-To: ezmlm-scan-internals@lists.php.net
Delivered-To: ezmlm-internals@lists.php.net
Received: (qmail 91659 invoked from network); 15 Apr 2004 13:15:05 -0000
Received: from unknown (HELO postfix3-1.free.fr) (213.228.0.44)
  by pb1.pair.com with SMTP; 15 Apr 2004 13:15:05 -0000
Received: from imp5-q.free.fr (imp5-q.free.fr [212.27.42.5])
	by postfix3-1.free.fr (Postfix) with ESMTP id 465DFC4173
	for <internals@lists.php.net>; Thu, 15 Apr 2004 15:15:05 +0200 (CEST)
Received: by imp5-q.free.fr (Postfix, from userid 33)
	id 3C0421172B; Thu, 15 Apr 2004 15:15:05 +0200 (MEST)
Received: from 217.167.226.103 ([217.167.226.103]) 
	by imp5-q.free.fr (IMP) with HTTP 
	for <mickael.bailly@imap.free.fr>; Thu, 15 Apr 2004 15:15:05 +0200
Message-ID: <1082034905.407e8ad929f64@imp5-q.free.fr>
Date: Thu, 15 Apr 2004 15:15:05 +0200
To: internals@lists.php.net
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.2.1
Subject: BugReport reproductible: sqlite and multiple queries (PHP5.0.0RC1)
From: mickael.bailly@free.fr

 
        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