Skip to content

mysql_tquery_file linefeed not properly parsed #166

@Vince0789

Description

@Vince0789

Linefeeds (LF, \n) aren't properly parsed when reading the file. The next line is appended to the previous one without a space in between which causes errors in queries that span more than one line. Adding a space before the linefeed solves the problem but it is annoying nonetheless.

SELECT h.id, h.doorx, h.doory, h.doorz, IFNULL(k.accountid, 0) AS ownerid
FROM House h
LEFT JOIN
(
	SELECT k.houseid, k.accountid, MIN(obtained)
	FROM HouseKey k
	GROUP BY k.houseid
) k 
ON k.houseid = h.id
ORDER BY h.id;

[22:26:28] [ERROR] error #1064 while executing query "SELECT h.id, h.doorx, h.doory, h.doorz, IFNULL(k.accountid, 0) AS owneridFROM House hLEFT JOIN( SELECT k.houseid, k.accountid, MIN(obtained) FROM HouseKey k GROUP BY k.houseid) k ON k.houseid = h.idORDER BY h.id;": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'House hLEFT JOIN( SELECT k.houseid, k.accountid, MIN(obtained) FROM HouseKey k G' at line 1

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions