Bug #64137 | slash in commands is not detected for which OS | ||
---|---|---|---|
Submitted: | 26 Jan 2012 17:58 | Modified: | 12 Feb 2012 16:20 |
Reporter: | Emanuel Calvo Franco | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
Version: | 5.2.35 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | slash |
[26 Jan 2012 17:58]
Emanuel Calvo Franco
[27 Jan 2012 7:31]
Valeriy Kravchuk
Please, explain what exactly is a bug in Workbench here, or what exactly you ask to change/implement in Workbench. Should it change text of SQL statements you send based on OS of target MySQL server?
[27 Jan 2012 9:19]
Emanuel Calvo Franco
For exmaple, in Windows version of workbench and the server is a Linux if you execute this: LOAD DATA LOCAL INFILE '/home/ppp/files/data/urls_temp.csv' INTO TABLE categorization.urls CHARACTER SET latin1 FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' (url,channel); It will through an error: Error Code: 2. File '\home\ppp\files\data\urls_temp.csv' not found (Errcode: 2)
[27 Jan 2012 9:21]
Emanuel Calvo Franco
I understand that workbench is trying to load a local file instead importing the server side file. Is this a limitation?
[12 Feb 2012 16:20]
Alfredo Kojima
LOAD DATA LOCAL INFILE will load data from LOCAL file: http://dev.mysql.com/doc/refman/5.1/en/load-data.html