ID: 41604 Updated by: [EMAIL PROTECTED] Reported By: ebine dot yutaka at servise dot jp -Status: Open +Status: Bogus Bug Type: InterBase related Operating System: Debian 4.1 PHP Version: 5.2.3 Assigned To: abies New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. MySQL doesn't allow DDL in Transactions, too. And anyways this is no PHP problem, PHP doesn't care/know about Transactions and the database has to do this. Previous Comments: ------------------------------------------------------------------------ [2007-06-06 10:30:24] ebine dot yutaka at servise dot jp sorry. I forget open. ------------------------------------------------------------------------ [2007-06-06 09:25:22] ebine dot yutaka at servise dot jp Other databases do not have this problem. For instance, it is Mysql, Postgresql, and Sqlite... and console(isql). I think this is bug. Because, we cannot use 'CREATE TABLE' in a transaction. If processing fails(even any one), this table is needless. -> rollback(not commit) ------------------------------------------------------------------------ [2007-06-06 06:20:48] [EMAIL PROTECTED] Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php You need to commit the transaction for the 'CREATE TABLE...' to take effect. ------------------------------------------------------------------------ [2007-06-06 06:16:02] [EMAIL PROTECTED] Ard, do you think it's PHP problem? ------------------------------------------------------------------------ [2007-06-06 05:15:16] ebine dot yutaka at servise dot jp add a postscript. sorry. --------------------------------------------- console -> isql(isql-fb) -> SET TRANSACTION {Various parameters}; CREATE TABLE test (id INTEGER); INSERT INTO test VALUES(1); COMMIT; --------------------------------------------- success. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/41604 -- Edit this bug report at http://bugs.php.net/?id=41604&edit=1
