|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #62889 LOAD DATA INFILE broken
Submitted: 2012-08-22 10:14 UTC Modified: 2014-01-01 12:35 UTC
Avg. Score:4.7 ± 0.7
Reproduced:24 of 24 (100.0%)
Same Version:11 (45.8%)
Same OS:9 (37.5%)
From: phpbugs2012 at joern dot heissler dot de Assigned: mysql
Status: Assigned Package: PDO MySQL
PHP Version: master-Git-2012-08-22 (Git) OS:
Private report: No CVE-ID:
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: phpbugs2012 at joern dot heissler dot de
New email:
PHP Version: OS:


 [2012-08-22 10:14 UTC] phpbugs2012 at joern dot heissler dot de
#46964 introduced a new bug. The patch there to fix compilation issues actually breaks the feature.

ext/pdo_mysql/mysql_driver.c has this line:

MYSQL_OPT_LOCAL_INFILE is not a macro. It's an enum.
The defined() will always be false and the block will not be compiled.

One way to fix this is to add a configure check which compiles a program like this:
#include <mysql/mysql.h>

When it cannot be compiled, the enum isn't defined. Then define some macro or so which can be checked by the preprocessor.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2012-10-25 10:48 UTC]
-Assigned To: +Assigned To: mysql
 [2014-01-01 12:35 UTC]
-Package: PDO related +Package: PDO MySQL
 [2015-02-03 20:11 UTC] phpbugs2012 at joern dot heissler dot de
Work around for the problem:
* add to options array: PDO::MYSQL_ATTR_READ_DEFAULT_GROUP => 'client'
* add to /etc/mysql/my.cnf:
local-infile = 1
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Mon Apr 24 15:01:45 2017 UTC