JPAStorageServiceTest and MySQL ?

[Tom Zeller]

It looks like JPAStorageServiceTest fails when using MySQL because
"key" is a reserved word.

The SQL is :

create table StorageRecords (
 context varchar(255) not null,
 key varchar(255) not null,
 expiration bigint,
 value varchar(255) not null,
 version bigint not null,
 primary key (context, key))

and the error is :

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ...

but this works :

create table StorageRecords (
 context varchar(255) not null,
 `key` varchar(255) not null,
 expiration bigint,
 value varchar(255) not null,
 version bigint not null,
 primary key (context, `key`))