From: [EMAIL PROTECTED]
Operating system: NT4
PHP version: 4.1.2
PHP Bug Type: MSSQL related
Bug description: Multiple statement in a query cause subsequent queries to fail
I am creating tables and indexes in a few places. To make life a little
easier I want to create a table and it's indexes in one go.
The following code fails:
----
$queries[0]["query_string"]="CREATE TABLE objects (
[id] integer IDENTITY (1,1) PRIMARY KEY,
[type] varchar(16) DEFAULT '' NOT NULL,
[object] text,
[vtype] varchar(16) DEFAULT '' NOT NULL,
[lastchanged] TIMESTAMP);
CREATE INDEX objects_lastchanged ON objects (lastchanged);";
$queries[1]["query_string"]="CREATE TABLE nodes (
path varchar(127) DEFAULT '' NOT NULL PRIMARY KEY,
parent varchar(127) DEFAULT '' NOT NULL,
object numeric(11) DEFAULT '0' NOT NULL,
priority numeric(11) DEFAULT '0' NOT NULL
);";
while ((list($key, $query)=each($queries)) && (!$error)) {
echo $query["query_string"];
$exec=mssql_query($query["query_string"]);
}
----
But if I separate out the create index into a separate query it works
fine.
--
Edit bug report at http://bugs.php.net/?id=16277&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=16277&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=16277&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16277&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16277&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16277&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16277&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16277&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16277&r=submittedtwice
