[#SES-660] Deprecated create table syntax on MySQL.

Issue Details [XML]

Key:	SES-660
Type:	Bug
Status:	Resolved
Resolution:	Fixed
Priority:	Critical
Assignee:	Arjohn Kampman
Reporter:	Petri Ahola
Votes:	1
Watchers:	0

Operations

If you were logged in you would be able to see more operations.

Sesame

Deprecated create table syntax on MySQL.

Created: 02/Feb/09 10:48 AM Updated: 08/Jun/11 10:49 AM

Component/s:

RDBMS Sail

Affects Version/s:

2.2.4, 2.4.0

Fix Version/s:

2.4.1

File Attachments:	1. MySQL_StorageEngineSyntax.patch (0.6 kb)
Environment:	MySQL 5.1.8+

Description

This produces just warnings on latest MySQL GA releases but prevents developing on upcoming releases.

From dev.mysql.com:
"The older TYPE option was synonymous with ENGINE. TYPE has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed as of MySQL 5.2."

All

Comments

Change History

Sort Order:

[ Permlink ]

Comment by Petri Ahola [02/Feb/09 10:56 AM]

Oh.. and to fix this. Just change "type = InnoDB" to "ENGINE = InnoDB".

[ Permlink ]

Comment by James Leigh [28/May/11 02:14 AM]

Patch looks good to me

[ Permlink ]

Comment by Arjohn Kampman [08/Jun/11 10:49 AM]

Patch has been applied in rev 11038:

http://repo.aduna-software.org/websvn/comp.php?repname=aduna&path=%2F&compare[]=%2Forg.openrdf%2Fsesame%2Fbranches%2F2.4@11027&compare[]=%2Forg.openrdf%2Fsesame%2Fbranches%2F2.4@11038