Project

General

Profile

Actions

Feature #21944

closed

MySQL extended INSERT statements cannot be parsed

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

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

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

MySQL dumps typically contain extended INSERT:

INSERT INTO table (col1, col2, col3) VALUES (v1,v2,v3),(v4,v5,v6),(v7,v8,v9),...

and cannot be parsed. This would be useful when importing a MySQL dump and should be available as multiple insert is/will be supported with #21753.

(issue imported from #M13209)


Files

13209_core.diff (4.85 KB) 13209_core.diff Administrator Admin, 2010-02-07 00:23
13209_dbal.diff (2.53 KB) 13209_dbal.diff Administrator Admin, 2010-02-07 00:23
13209_dbal_v2.diff (6.07 KB) 13209_dbal_v2.diff Administrator Admin, 2010-02-07 13:56

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Feature #21753: Provide an API to insert multiple rows at onceClosedChristian Kuhn2009-11-30

Actions
Actions #1

Updated by Xavier Perseguers almost 15 years ago

BEWARE: Method compileINSERT is overriden in DBAL (class.ux_t3lib_sqlparser.php) and should be updated there too!

Actions #2

Updated by Xavier Perseguers almost 15 years ago

v2 of DBAL patch fixes the compileINSERT problem.

Actions #3

Updated by Xavier Perseguers almost 15 years ago

Committed to Core trunk (rev. 6859) and DBAL trunk (rev. 29765)

Actions

Also available in: Atom PDF