[TYPO3-core] FYI #13430: Cannot parse INSERT when VALUES has no space before left parenthesis

[Xavier Perseguers]

Hi,

FYI, the following patches have been committed to:

- Trunk (rev. 6855)
- 4-3 (rev. 6856)

Tests have been committed to DBAL trunk and branch 1-0.



Type: Bugfix

Bugtracker reference:
http://bugs.typo3.org/view.php?id=13430

Problem:
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('483', '0', 'NL', 'NLD', '528', 'DR', 'Dren"". Query: "INSERT INTO static_country_zones 
VALUES('483', '0', 'NL', 'NLD', '528', 'DR', 'Drenthe', '');"

Full INSERT statement looks like this:

INSERT INTO static_country_zones VALUES('483', '0', 'NL', 'NLD', '528', 'DR', 'Drenthe', '');

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

Additional information:
"Bug" has been introduced in static_info_tables recently (rev. 21636). This is probably due to a manual edit of the static data instead of dumping the list with mysqldump.

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13430_core.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100206/62c7e8e6/attachment.asc>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13430_dbal.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100206/62c7e8e6/attachment.txt>