Project

General

Profile

Actions
Copy link

Bug #24156

closed

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

Added by Jigal van Hemert about 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
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

Download all files
16501_core.diff (860 Bytes) 16501_core.diff Administrator Admin, 2010-11-30 16:11
16501_dbal.diff (1.13 KB) 16501_dbal.diff Administrator Admin, 2010-11-30 16:12

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #24150: Can't create table sys_registry from install toolClosed2010-11-20

Actions
Actions
Copy link
 #1

Updated by Xavier Perseguers almost 14 years ago

original create table definition is found in t3lib/stddb/tables.sql:

#
  1. Table structure for table 'sys_registry' #
    CREATE TABLE sys_registry (
    uid int(11) unsigned NOT NULL auto_increment,
    entry_namespace varchar(128) DEFAULT '' NOT NULL,
    entry_key varchar(128) DEFAULT '' NOT NULL,
    entry_value blob,
    PRIMARY KEY (uid),
    UNIQUE KEY entry_identifier (entry_namespace,entry_key)
    );
Actions
Copy link
 #2

Updated by Xavier Perseguers almost 14 years ago

Committed to:

- DBAL trunk (rev. 40682)
- Core trunk (rev. 9689)
- Core 4-4 (rev. 9690)
- Core 4-3 (rev. 9691)

Actions
Copy link

Also available in: Atom PDF