Issue Bug Closed

#24156DBAL does not support multi-column indexes in create table queries

Jigal van Hemert 11/21/10, 14:35 updated 01/31/11, 16:09

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.