Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 334985 - [DB] MySLQAdapter lacks keyword 'SIGNAL' from MySQL 5.5
Summary: [DB] MySLQAdapter lacks keyword 'SIGNAL' from MySQL 5.5
Status: CLOSED FIXED
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.core (show other bugs)
Version: 4.0   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Caspar D. CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-21 04:45 EST by Caspar D. CLA
Modified: 2011-06-23 03:41 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Caspar D. CLA 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. CLA 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. CLA 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 CLA 2011-01-21 05:04:04 EST 
Can you please fix this? No review needed.
Comment 4 Caspar D. CLA 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. CLA 2011-01-21 05:47:04 EST 
Committed to trunk, rev. 6876.
Comment 6 Eike Stepper CLA 2011-06-23 03:41:11 EDT 
Available in R20110608-1407