-
Notifications
You must be signed in to change notification settings - Fork 84
Description
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