Project

General

Profile

Actions

Bug #22061

closed

Cannot parse INSERT when VALUES has no space before left parenthesis

Added by Xavier Perseguers almost 15 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-02-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)


Files

13430_core.diff (694 Bytes) 13430_core.diff Administrator Admin, 2010-02-05 22:06
13430_dbal.diff (1.6 KB) 13430_dbal.diff Administrator Admin, 2010-02-05 22:07
Actions #1

Updated by Xavier Perseguers almost 15 years ago

Committed to:

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

Tests committed to DBAL:

- Trunk (rev. 29762)
- 1-0 (rev. 29763)

Actions

Also available in: Atom PDF