#35508 [Opn->Csd]: PDO returns SQLSTATE error on valid queries.
ID: 35508
Updated by: tony2001@php.net
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
Thread (2 messages)