Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 334985

Summary:	[DB] MySLQAdapter lacks keyword 'SIGNAL' from MySQL 5.5
Product:	[Modeling] EMF	Reporter:	Caspar D. <caspar_d>
Component:	cdo.core	Assignee:	Caspar D. <caspar_d>
Status:	CLOSED FIXED	QA Contact:	Eike Stepper <stepper>
Severity:	normal
Priority:	P3	CC:	saulius.tvarijonas, stepper
Version:	4.0
Target Milestone:	---
Hardware:	All
OS:	All
Whiteboard:

Description Caspar D.

2011-01-21 04:45:52 EST

SIGNAL is a reserved work in MySQL 5.5, but hasn't been added to the set
of reserved words in MYSQLAdapter.

Comment 1 Caspar D.

2011-01-21 04:51:09 EST

Problem can be reproduced by committing an object with an attribute named
'signal'. (Store must be configured to be MySQL, of course.)

Comment 2 Caspar D.

2011-01-21 04:54:49 EST

Actually it's not just SIGNAL.

Here are the new reserved words for MySQL 5.5:

GENERAL
IGNORE_SERVER_IDS
MASTER_HEARTBEAT_PERIOD
MAXVALUE
RESIGNAL
SIGNAL
SLOW

Comment 3 Eike Stepper

2011-01-21 05:04:04 EST

Can you please fix this? No review needed.

Comment 4 Caspar D.

2011-01-21 05:13:40 EST

Fetched the full list from 

  http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html

Diffed it against what we have now.

Looks like this is what has to be added in order to create the union
of what (presumably) was reserved in earlier versions of MySQL, and
what is reserved now:

ACCESSIBLE
GENERAL
IGNORE_SERVER_IDS
LINEAR
MASTER_HEARTBEAT_PERIOD
MASTER_SSL_VERIFY_SERVER_CERT
MAXVALUE
RANGE
READ_WRITE
RESIGNAL
SIGNAL
SLOW

Comment 5 Caspar D.

2011-01-21 05:47:04 EST

Committed to trunk, rev. 6876.

Comment 6 Eike Stepper

2011-06-23 03:41:11 EDT

Available in R20110608-1407