Project

General

Profile

Actions
Copy link

Bug #22695

closed

SQL parser doesn't accept ALTER TABLE statement without CHANGE, DROP or ADD keyword

Added by Francois Suter over 14 years ago. Updated over 14 years ago.

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

0%

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

Description

This means the SQL parser won't accept a statement like:

ALTER TABLE tx_realurl_pathcache ENGINE=InnoDB;

making it impossible to install an extension like RealURL.

(issue imported from #M14456)

Files

Download all files
14456_core.diff (1.88 KB) 14456_core.diff Administrator Admin, 2010-05-23 12:35
14456_dbal.diff (1.39 KB) 14456_dbal.diff Administrator Admin, 2010-05-23 12:35
Actions
Copy link
 #1

Updated by Xavier Perseguers over 14 years ago

Underlying error is:

SQL engine parse ERROR: No action CHANGE, DROP or ADD found!: near "ENGINE=InnoDB"

Actions
Copy link
 #2

Updated by Xavier Perseguers over 14 years ago

Francois,

Could you please test the attached patches? It should work according to my unit test but I'd like to have a feedback from you as your environment is set up to test this.

Thanks.

Actions
Copy link
 #3

Updated by Xavier Perseguers over 14 years ago

Committed to:

- TYPO3 trunk (rev. 7697)
- DBAL trunk (rev. 33591)
- DBAL_1-1 (rev. 33592)

Actions
Copy link

Also available in: Atom PDF