Actions
Bug #24156
closed
DBAL does not support multi-column indexes in create table queries
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-11-21
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
When DBAL is active, the install tool tries to create the sys_registry table. This table contains a UNIQUE key on two columns. The query parser fails to recognize this and creates:
CREATE TABLE sys_registry ( uid int(11) unsigned NOT NULL auto_increment, entry_namespace varchar(128) NOT NULL default '', entry_key varchar(128) NOT NULL default '', entry_value blob, PRIMARY KEY (uid), UNIQUE (Array) );
How to reproduce:
- (temporarily) remove sys_registry table
- install DBAL
- in Install Tool: Database Analyzer > COMPARE
- let tool try to create the sys_registry table
(issue imported from #M16501)
Files
Updated by
Actions