[#IDEA-17903] MySQL "LOAD DATA" statement is not supported in MySQL dialect

IDEA: Feedback

Created: 24 Apr 08 15:18 Updated: 18 May 08 18:04

Component/s:

SQL

Build:	8,280
Severity:	High

Description

« Hide

The MySQL SQL-extension "LOAD DATA INFILE" clause is not supported by IDEA's MySQL dialect. See http://dev.mysql.com/doc/refman/5.0/en/load-data.html for documentation of the syntax.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

In #8375, it looks better, but following code is still red:

LOAD DATA LOCAL INFILE ? IGNORE INTO TABLE country_codes FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '\t'
(   id , name , country_group_id ) ;

The "?" is highlighted as red. MySQL allows placing the file name as a JDBC parameter, so I think this should be allowed.