From: g dot m dot seed at hw dot ac dot uk
Operating system: Windows98
PHP version: 4.3.4
PHP Bug Type: MySQL related
Bug description: mysql load data query
Description:
------------
The "load data" with "local infile" is supported in MySQL4, and has been
since version 3.22. However, when an SQL query is submitted using
mysql_query() the error returned by mysql_error() states "The used command
is not allowed with this MySQL version"?
I have read through the php manual, mysql manual, php's bug search
facilities and checked a mailing group and can't find any reference that
states the "load data" command is not supported when using php4 and
mysql4?
Incidentally, the query executes as expected if run at the mysql> command
line prompt.
Comments on rebported bug #7244 state:
"LOAD DATA INFILE (without LOCAL) seems to be ok."
and it appears that the use of "local" is the problem. If so, then this is
contrary to the MySQL manual which clearly states the use of "local".
Furthermore, if you don't consider the omission of "local" to be a bug
then it should be documented since it is extremely difficult to pin this
one down.
Reproduce code:
---------------
$sqlQuery = "load data local infile 'filename.csv' into table exams fields
terminated by ',' enclosed by '\"' lines terminated by '\\r\\n'";
$result = mysql_query($sqlQuery)
or die("query failed, error=" . mysql_error() . "\n");
Expected result:
----------------
To insert the data from filename.csv
Actual result:
--------------
query failed, error=The used command is not allowed with this MySQL
version
--
Edit bug report at http://bugs.php.net/?id=28631&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28631&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28631&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=28631&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=28631&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=28631&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=28631&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=28631&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=28631&r=support
Expected behavior: http://bugs.php.net/fix.php?id=28631&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=28631&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=28631&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=28631&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28631&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=28631&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=28631&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=28631&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=28631&r=float
