Page MenuHomePhabricator

Manage MySQL Syntax Updates (TYPE==>ENGINE)
Closed, ResolvedPublic

Description

Author: jb.veyrieras

Description:
For MySQL version >= 5.5.8 the storage engine cannot be specied via TYPE= but only by ENGINE=.
Otherwise, when SM queries are big and need the creation of a temporary table, queries fail and return a MySQL syntax error code


Version: unspecified
Severity: trivial
OS: Windows Vista
Platform: PC

Details

Reference
bz28037

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:32 PM
bzimport set Reference to bz28037.

Also have a look at Bug 13586 - ENGINE vs TYPE

This has already been fixed on trunk (and the latest SMW release if I'm not mistaken).

jb.veyrieras wrote:

(In reply to comment #2)

This has already been fixed on trunk (and the latest SMW release if I'm not
mistaken).

May-be on trunk but I tested yersterday the last SMW release and I had to debug it by myslef ;-)
BTW, many thanks for all your great job on SMW.

I just checked an the fix indeed was part of the latest SMW release (1.5.6). Is this the version you have? And if so, where is the error occurring? I can't find any remaining 'TYPE's, but might be overlooking something.

jb.veyrieras wrote:

Oups ! My mistake.
I was talking about the last release of semantic-bundle for which the SMW extension is of lower version. Sorry about that.