Bug #67445: ALTER TABLE ADD KEY / DROP KEY unsupported - TYPO3 Core - TYPO3 Forge

Custom queries

Accessibility
Easy tasks
Forge Triage
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
My open issues
No feedback within 90 days
Open Bugs
Open issues of 10
Recently modified
Regressions
Stabilization Issues
Usability or UX

Actions

Copy link

Bug #67445

closed

ALTER TABLE ADD KEY / DROP KEY unsupported

Added by Morton Jonuschat over 9 years ago. Updated about 6 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Morton Jonuschat

Category:

Database API (Doctrine DBAL)

Target version:

Start date:

2015-06-14

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

5.6

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

Using DBAL it is currently not possible to add or drop indexes. Only a partial/invalid query is generated from the MySQL Statement in the SQL Parser.

Input:

ALTER TABLE pages ADD KEY determineSiteRoot (is_siteroot);

Statement generated by SQL Parser:

 (is_siteroot)

Environment: TYPO3 7.3-dev@master
Database: PostgreSQL 9.4

Related issues 1 (0 open — 1 closed)

Blocks TYPO3 Core - Feature #67301: Don't suggest database alterations for functionally equivalent field types with DBAL

Closed

Morton Jonuschat

2015-06-05

Actions

Issue # Delay: days Cancel

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Frank Nägler over 9 years ago

Category set to 999

Actions

Copy link

Updated by Morton Jonuschat over 9 years ago

Assignee set to Morton Jonuschat

Actions

Copy link

Updated by Morton Jonuschat over 9 years ago

Status changed from New to In Progress

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Status changed from In Progress to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

#10

Updated by Gerrit Code Review over 9 years ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

#11

Updated by Stephan Großberndt over 9 years ago

Status changed from Under Review to In Progress

Actions

Copy link

#12

Updated by Gerrit Code Review over 9 years ago

Status changed from In Progress to Under Review

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

#13

Updated by Gerrit Code Review over 9 years ago

Patch set 9 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40397

Actions

Copy link

#14