|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #35508 PDO returns SQLSTATE error on valid queries.
Submitted: 2005-12-01 19:35 UTC Modified: 2005-12-01 21:01 UTC
From: capiCrimm at gmail dot com Assigned:
Status: Closed Package: PDO related
PHP Version: 5.1.1 OS: Debian
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: capiCrimm at gmail dot com
New email:
PHP Version: OS:


 [2005-12-01 19:35 UTC] capiCrimm at gmail dot com
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:

$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  


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-12-01 21:01 UTC]
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
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.
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Tue Oct 19 09:03:37 2021 UTC