Project

General

Profile

Actions
Copy link

Bug #50466

closed

MySQL: Use ENGINE instead of deprecated TYPE for storage-engine

Added by Stefan Neufeind over 11 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Stefan Neufeind
Category:
Install Tool
Target version:
-
Start date:
2013-07-26
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
easy
Is Regression:
Sprint Focus:

Description

CREATE-statements often still use TYPE instead of ENGINE. Since those statements are analysed already it should be possible to substitute this parameter quite easy.

I just had CREATE-statements failing (!) because of TYPE being used on MySQL 5.5.something. I can't say exactly since when it was dropped finally but it's definitely deprecated since 4.x

http://dev.mysql.com/doc/refman/4.1/en/create-table.html states “ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1).” and then notes that TYPE is deprecated

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #25067: Add compatibility with MySQL 5.5: Replace "TYPE" with "ENGINE"Closed2011-02-17

Actions
Actions
Copy link
 #1

Updated by Jigal van Hemert over 11 years ago

http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html

  • Incompatible change: As of MySQL 5.1.8, TYPE = engine_name is still accepted as a synonym for the ENGINE = engine_name table option but generates a warning. You should note that this option is not available in MySQL 5.1.7, and is removed altogether in MySQL 5.5 and produces a syntax error.

TYPE has been deprecated since MySQL 4.0.

Actions
Copy link
 #2

Updated by Gerrit Code Review over 11 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/22592

Actions
Copy link
 #3

Updated by Philipp Gampe over 11 years ago

  • Assignee set to Stefan Neufeind
  • Complexity set to easy
Actions
Copy link
 #4

Updated by Gerrit Code Review over 11 years ago

Patch set 2 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/22592

Actions
Copy link
 #5

Updated by Gerrit Code Review over 11 years ago

Patch set 1 for branch TYPO3_6-1 has been pushed to the review server.
It is available at https://review.typo3.org/22792

Actions
Copy link
 #6

Updated by Gerrit Code Review over 11 years ago

Patch set 1 for branch TYPO3_6-0 has been pushed to the review server.
It is available at https://review.typo3.org/22793

Actions
Copy link
 #7

Updated by Gerrit Code Review over 11 years ago

Patch set 2 for branch TYPO3_6-0 has been pushed to the review server.
It is available at https://review.typo3.org/22793

Actions
Copy link
 #8

Updated by Gerrit Code Review over 11 years ago

Patch set 2 for branch TYPO3_6-1 has been pushed to the review server.
It is available at https://review.typo3.org/22792

Actions
Copy link
 #9

Updated by Stefan Neufeind over 11 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #10

Updated by Gerrit Code Review over 11 years ago

  • Status changed from Resolved to Under Review

Patch set 1 for branch TYPO3_4-7 has been pushed to the review server.
It is available at https://review.typo3.org/22797

Actions
Copy link
 #11

Updated by Gerrit Code Review over 11 years ago

Patch set 1 for branch TYPO3_4-5 has been pushed to the review server.
It is available at https://review.typo3.org/22798

Actions
Copy link
 #12

Updated by Stefan Neufeind over 11 years ago

  • Status changed from Under Review to Resolved
Actions
Copy link
 #13

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF