Bug #38134 LOAD DATA INFILE description is missing COLUMNS synonym for FIELDS
Submitted: 15 Jul 2008 13:16 Modified: 17 Jul 2008 15:42
Reporter: Kay Roepke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[15 Jul 2008 13:16] Kay Roepke 
Description:
The description for LOAD DATA INFILE (http://dev.mysql.com/doc/refman/5.1/en/load-data.html) does not mention the COLUMNS keyword which can be used as a synonym.

How to repeat:
LOAD DATA INFILE '/tmp/data.txt' INTO TABLE valtest COLUMNS OPTIONALLY ENCLOSED BY '!';

Suggested fix:
add to syntax description.
[15 Jul 2008 14:03] Susanne Ebrecht 
Verified as described. According to parser from MySQL 5.1 bzr tree.
[17 Jul 2008 15:42] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

This is a consequence of the fact that the lexer treats COLUMNS and FIELDS as the same symbol.