Issue Bug Closed

#22061Cannot parse INSERT when VALUES has no space before left parenthesis

Xavier Perseguers 02/05/10, 10:25 updated 02/13/10, 15:05

Description

When trying to import static data of EXT:static_info_tables, the operation fails with

ERROR: Query could not be parsed: “SQL engine parse ERROR: No ( parenthesis starting the list: near “VALUES;”

Full INSERT statement looks like this:

INSERT INTO static_country_zones VALUES;

Problem is that it misses a blank space between token VALUES and left parenthesis. This bugs the SQL parser.

“Bug” has been introduced in static_info_tables recently:

http://forge.typo3.org/repositories/diff/extension-static_info_tables/trunk/ext_tables_static+adt.sql?rev=21636

This is probably due to a manual edit of the static data instead of dumping the list with mysqldump.
(issue imported from #M13430)

Reviews 0

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