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
