Bug #65354
closedSupport for SPATIAL KEY in Schema / Migration
100%
Description
Given the following definition in ext_tables.sql the Install Tool wants to re-create the index every time a database compare is being performed.
# # Table structure for tables 'tx_sitelist_domain_model_zipcode' # CREATE TABLE tx_spatial_domain_model_zipcode ( zipcode varchar(16) DEFAULT '' NOT NULL, place varchar(255) DEFAULT '' NOT NULL, location point DEFAULT '' NOT NULL, KEY zipcode (zipcode), SPATIAL KEY location (location) ) ENGINE=MyISAM;
1. An existing index is not being detected properly (wrong/unknown) type, this leads to being offered to drop existing index as well as creating the new index
2. Re-creating the index after database compare leads to duplicate index errors, it seems dropping the existing index would be performed after the new index has been created
Updated by Stephan Großberndt over 9 years ago
- Tracker changed from Feature to Bug
- TYPO3 Version set to 6.2
- Is Regression set to No
Updated by Gerrit Code Review over 9 years ago
- Status changed from New 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/38953
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/38953
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/38953
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/38953
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/38953
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/38953
Updated by Morton Jonuschat over 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset afd54ca727cdbf082e488692b2746a37033d45d0.