[#MDEV-4116] LOAD_FILE() does not understand paths with '\'

[MDEV-4116] LOAD_FILE() does not understand paths with '\' Created: 2013-01-30 Updated: 2013-01-30 Resolved: 2013-01-30
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	10.0.0, 5.5.28a, 5.3.11, 5.2.13, 5.1.66
Fix Version/s:	None

Type:

Bug

Priority:

Minor

Reporter:

Federico Razzoli

Assignee:

Unassigned

Resolution:

Not a Bug

Votes:

Labels:

None

Environment:

WinXP

Description

If I specify file path using '\' (which is usually used on Windows) LOAD_FILE() doesn't find the file, while it works using '/'.

Create test.sql and issue:

SELECT LOAD_FILE('c:\test.sql'), LOAD_FILE('c:/test.sql');

Comments

Comment by Vladislav Vaintroub [ 2013-01-30 ]

In MySQL, backslash is used as mask character inside the string : http://dev.mysql.com/doc/refman/5.5/en/string-literals.html

If you need a string with backslash, you'd need to duplicate it , e.g C:
test.sql

Generated at Thu Feb 08 06:53:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.