#48859 [Ana->Opn]: PDO mysql does not support multiple inital queries
| From: | kalle@php.net | Date: | Sat, 01 Aug 2009 11:10:55 +0000 |
| Subject: | #48859 [Ana->Opn]: PDO mysql does not support multiple inital queries | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-140554@lists.php.net to get a copy of this message | ||
ID: 48859
Updated by: kalle@php.net
Reported By: techi at techi dot name
-Status: Analyzed
+Status: Open
-Bug Type: PDO related
+Bug Type: Feature/Change Request
Operating System: *
PHP Version: 5.2.10
Previous Comments:
------------------------------------------------------------------------
[2009-07-22 07:46:54] kalle@php.net
The question here is trival, because internally we use
mysql_options(MYSQL_INIT_COMMAND) which does not support multiple
queries then. We could probably work around it with some hackish code,
but I'll leave this up to the mysql guys to judge
------------------------------------------------------------------------
[2009-07-08 22:59:46] techi at techi dot name
Description:
------------
When using intial SQL query with PDO::MYSQL_ATTR_INIT_COMMAND, only one
query can be queried. More queries throws exception SQLSTATE[HY000]:
General error: 2014
I am not sure, if this is bug or feature or some PDO limitation, but
sometimes more than one initial query is needed
Reproduce code:
---------------
$pdo = new PDO(
'mysql:host=hostname;dbname=defaultDbName',
'username',
'password',
array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8;SET time_zone
= 'Europe/Prague'")
);
Actual result:
--------------
SQLSTATE[HY000]: General error: 2014
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=48859&edit=1