Issue Bug Closed

#21887SQL parser cannot parse escaped single quote in INSERT statement

Xavier Perseguers 12/27/09, 14:08 updated 02/05/10, 22:33

Description

When trying to import static data from EXT:static_info_tables, the script dies with typical error:

ERROR: Query could not be parsed: “SQL engine parse ERROR: No ) parenthesis in list: near “Andorra’, ‘Principality of Andorra’, ‘Andorra la Vella’, ‘ad’, ‘EUR’, ‘978’, ‘376’, ‘0’, ‘1’, ‘0’, ‘Andorra’, ‘Andorra’, ‘1’) “”. Query: “INSERT INTO static_countries VALUES (‘1’, ‘0’, ‘0’, ‘AD’, ‘AND’, ‘20’, ‘39’, ‘Principat d\‘Andorra’, ‘Principality of Andorra’, ‘Andorra la Vella’, ‘ad’, ‘EUR’, ‘978’, ‘376’, ‘0’, ‘1’, ‘0’, ‘Andorra’, ‘Andorra’, ‘1’);”

This is cause by the escaped single quote in “Principat d\‘Andorra”

(issue imported from #M13104)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.