Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:9184
Return-Path: <wez@thebrainroom.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 23668 invoked by uid 1010); 15 Apr 2004 13:22:17 -0000
Delivered-To: ezmlm-scan-internals@lists.php.net
Delivered-To: ezmlm-internals@lists.php.net
Received: (qmail 23630 invoked from network); 15 Apr 2004 13:22:16 -0000
Received: from unknown (HELO mx.thebrainroom.net) (65.200.24.98)
  by pb1.pair.com with SMTP; 15 Apr 2004 13:22:16 -0000
Received: by mx.thebrainroom.net (Postfix, from userid 517)
	id A24C914880BD; Thu, 15 Apr 2004 06:22:15 -0700 (PDT)
Received: from tron (zaneeb.thebrainroom.net [82.133.1.138])
	(using TLSv1 with cipher RC4-MD5 (128/128 bits))
	(No client certificate requested)
	by mx.thebrainroom.net (Postfix) with SMTP
	id C244714880B7; Thu, 15 Apr 2004 06:22:12 -0700 (PDT)
Message-ID: <03ed01c422ec$c1603330$8a02a8c0@tron>
To: <mickael.bailly@free.fr>, <internals@lists.php.net>
References: <1082034905.407e8ad929f64@imp5-q.free.fr>
Date: Thu, 15 Apr 2004 14:22:50 +0100
Organization: The Brain Room Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Spam-Status: No, hits=-0.9 required=5.0
	tests=AWL,BAYES_30,QUOTED_EMAIL_TEXT,REFERENCES
	version=2.55
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp)
X-TBR-Filter: Virus scanned and defanged
Subject: Re: [PHP-DEV] BugReport reproductible: sqlite and multiple queries (PHP5.0.0RC1)
From: wez@thebrainroom.com ("Wez Furlong")

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
>
>
> -- 
> PHP Internals - PHP Runtime Development Mailing List
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>