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:
None 
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
Description:

the / is taken as \ in windows, but the server is in a linux side. so it could be great to detect which os is host for the server and use \ or / , depending on that.

How to repeat:
With load data infile is the most common example
[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