ID: 35508 Updated by: [EMAIL PROTECTED] Reported By: capiCrimm at gmail dot com -Status: Open +Status: Closed Bug Type: PDO related Operating System: Debian PHP Version: 5.1.1 New Comment:
This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. JFYI: all PDO constants were changed to class constants before 5.1 release. Previous Comments: ------------------------------------------------------------------------ [2005-12-01 19:35:18] capiCrimm at gmail dot com Description: ------------ When creating a temporary table with PDO it returns an error when you try to use the table. The database I'm running is mysql 14.7. The queries run fine in mysql CLI. I've tried switching around the query values and changing tables and databases. Error occurs both in php CLI and mod_php. I'm pretty sure Temp tables were working in RC1, though I may be remembering wrong. Reproduce code: --------------- <?php $pdoConnection = new PDO('mysql:dbname=gDev;host=localhost;','root',''); $pdoConnection->query('CREATE TEMPORARY TABLE TestC(str1 INT(1),str2 INT(1));'); $pdoConnection->query("INSERT INTO TestC VALUES(1,1);", PDO_RESULT_ASSOC); // line 6 ?> Expected result: ---------------- A Blank Page Actual result: -------------- Warning: PDO::query() [function.query]: SQLSTATE[22003]: Numeric value out of range: unhandled mode; this is a PDO bug, please report it in /file.php on line 6 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35508&edit=1
