#21887SQL parser cannot parse escaped single quote in INSERT statement
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.