#43246 [Opn]: firebird: INSERT ... RETURNING ... throws exception

ID: 43246 User updated by: hp-php dot net at oeri dot ch Reported By: hp-php dot net at oeri dot ch Status: Open Bug Type: PDO related Operating System: Linux 2.6 PHP Version: 5.3CVS-2007-11-11 (CVS) New Comment: INSERT ... RETURNING works fine with pdo_pgsql. An "indice" for a problem within pdo_firebird (and not pdo itself). Previous Comments: ------------------------------------------------------------------------ [2007-11-11 14:24:59] hp-php dot net at oeri dot ch Description: ------------ Executing (prepared or directly) an "INSERT ... RETURNING" throws an exception Reproduce code: --------------- <?php $pdo = new PDO( 'firebird:dbname=localhost:devel', 'devel', 'devel' ); $pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); // VARIANT A: ORDINARY INSERT $stmt = $pdo->query( 'INSERT INTO "a" ("data") VALUES (2500)' ); echo "Variant 'A': done"; // VARIANT B: RETURNING INSERT $stmt = $pdo->query( 'INSERT INTO "a" ("data") VALUES (2500) RETURNING "data"' ); $res = $stmt->fetchAll( PDO::FETCH_ASSOC ); print_r( $res ); echo "Variant 'B': done"; ?> Expected result: ---------------- Variant 'A': done Variant 'B': done (Both statements executed) Actual result: -------------- Variant 'A': done<br /> <b>Fatal error</b>: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: -804 Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure ' in PHPDocument4:11 Stack trace: #0 PHPDocument4(11): PDO-&gt;query('INSERT INTO &quot;a&quot;...') #1 /var/www/devel/htdocs/dummy.php(1): include('PHPDocument4') #2 {main} thrown in <b>PHPDocument4</b> on line <b>11</b><br /> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=43246&edit=1