ID: 41604
User updated by: ebine dot yutaka at servise dot jp
Reported By: ebine dot yutaka at servise dot jp
Status: Open
Bug Type: InterBase related
Operating System: Debian 4.1
PHP Version: 5.2.3
New Comment:
add a postscript. sorry.
---------------------------------------------
console -> isql(isql-fb) ->
SET TRANSACTION {Various parameters};
CREATE TABLE test (id INTEGER);
INSERT INTO test VALUES(1);
COMMIT;
---------------------------------------------
success.
Previous Comments:
------------------------------------------------------------------------
[2007-06-06 03:53:57] ebine dot yutaka at servise dot jp
Description:
------------
'INSERT' after 'CREATE TABLE' doesn't work when the transaction is
used.
I think that 'INSERT' can't see the table.
It doesn't work similarly even if various Isolation Level is passed.
I think that this is not a so recent problem.
php5.2.2, 5.2.1, 5.2.0, 5.1.x ... and operating systems are Ubuntu,
FreeBSD, MaxOS... etc.
Sorry, my poor english.
Reproduce code:
---------------
$conn = ibase_connect("localhost:/home/firebird/test.fdb", "user",
"password");
$trans = ibase_trans(IBASE_DEFAULT, $conn);
//$trans = ibase_trans(IBASE_WRITE|IBASE_CONCURRENCY|IBASE_WAIT,
$conn);
//$trans = ibase_trans(IBASE_COMMITTED|IBASE_REC_VERSION, $conn);
ibase_query($trans, "CREATE TABLE test (id INTEGER)");
ibase_query($trans, "INSERT INTO test VALUES (1)");
ibase_commit($trans);
Expected result:
----------------
I think that these two query should succeed.
Actual result:
--------------
I received error message.
ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown
TEST At line 1, column 13.
But, the table was made.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41604&edit=1
