#35508 [NEW]: PDO returns SQLSTATE error on valid queries.

From: capiCrimm at gmail dot com Operating system: Debian PHP version: 5.1.1 PHP Bug Type: PDO related Bug description: PDO returns SQLSTATE error on valid queries. 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 bug report at http://bugs.php.net/?id=35508&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=35508&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=35508&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=35508&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=35508&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35508&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35508&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35508&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35508&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35508&r=support Expected behavior: http://bugs.php.net/fix.php?id=35508&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35508&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35508&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35508&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35508&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35508&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35508&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35508&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35508&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35508&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35508&r=mysqlcfg