Bug #57899 Certain reserved words should not be reserved
Submitted: 1 Nov 2010 15:46 Modified: 6 Jan 2011 16:40
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.5 OS:Linux (SUSE 11 64-bit)
Assigned to: Luis Soares CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[1 Nov 2010 15:46] Peter Gulutzan
Description:
In MySQL 5.5 the new reserved words include:
SLOW                    as in FLUSH SLOW LOGS
GENERAL                 as in FLUSH GENERAL LOGS
IGNORE_SERVER_IDS       as in CHANGE MASTER ... IGNORE_SERVER_IDS
MASTER_HEARTBEAT_PERIOD as in CHANGE MASTER ... MASTER_HEARTBEAT_PERIOD

These are not reserved words in standard SQL,
or in Oracle 11g.

Some other FLUSH and CHANGE MASTER keywords are
not reserved in this position.

Unnecessary reserving is a behaviour change
which may affect an existing application somewhere.

How to repeat:
mysql> create table general (general int);
ERROR 1064 (42000): 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 'general (general int)' at line 1
[1 Nov 2010 15:54] Miguel Solorzano
Thank you for the bug report.
[2 Nov 2010 11:50] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/122522

3108 Luis Soares	2010-11-02
      BUG#57899: Certain reserved words should not be reserved
      
      In MySQL 5.5 the new reserved words include:
      SLOW                    as in FLUSH SLOW LOGS
      GENERAL                 as in FLUSH GENERAL LOGS
      IGNORE_SERVER_IDS       as in CHANGE MASTER ... IGNORE_SERVER_IDS
      MASTER_HEARTBEAT_PERIOD as in CHANGE MASTER ... MASTER_HEARTBEAT_PERIOD
      
      These are not reserved words in standard SQL, or in Oracle 11g,
      and as such, may affect existing applications.
      
      We fix this by adding the new words to the list of 
      keywords that we allow for labels in SPs.
     @ mysql-test/t/keywords.test
        Test case that checks that the target words can be used
        for naming fields in a table or as local routine variable
        names.
[3 Nov 2010 7:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/122599

3108 Luis Soares	2010-11-03
      BUG#57899: Certain reserved words should not be reserved
      
      In MySQL 5.5 the new reserved words include:
      SLOW                    as in FLUSH SLOW LOGS
      GENERAL                 as in FLUSH GENERAL LOGS
      IGNORE_SERVER_IDS       as in CHANGE MASTER ... IGNORE_SERVER_IDS
      MASTER_HEARTBEAT_PERIOD as in CHANGE MASTER ... MASTER_HEARTBEAT_PERIOD
      
      These are not reserved words in standard SQL, or in Oracle 11g,
      and as such, may affect existing applications.
      
      We fix this by adding the new words to the list of 
      keywords that are allowed for labels in SPs.
     @ mysql-test/t/keywords.test
        Test case that checks that the target words can be used
        for naming fields in a table or as local routine variable
        names.
[3 Nov 2010 14:52] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/122720

3108 Luis Soares	2010-11-03
      BUG#57899: Certain reserved words should not be reserved
      
      In MySQL 5.5 the new reserved words include:
      SLOW                    as in FLUSH SLOW LOGS
      GENERAL                 as in FLUSH GENERAL LOGS
      IGNORE_SERVER_IDS       as in CHANGE MASTER ... IGNORE_SERVER_IDS
      MASTER_HEARTBEAT_PERIOD as in CHANGE MASTER ... MASTER_HEARTBEAT_PERIOD
      
      These are not reserved words in standard SQL, or in Oracle 11g,
      and as such, may affect existing applications.
      
      We fix this by adding the new words to the list of 
      keywords that are allowed for labels in SPs.
     @ mysql-test/t/keywords.test
        Test case that checks that the target words can be used
        for naming fields in a table or as local routine variable
        names.
[5 Nov 2010 8:24] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/122893

3109 Luis Soares	2010-11-05
      BUG#57899: Certain reserved words should not be reserved
      
      Small fix for the test case. The column named "slow" was
      used twice in the SELECTs. As a consequence, the column
      named "ignore_server_ids" was not used.
      
      To fix this we simply replace the second column selected 
      named "slow" with a column named "ignore_server_ids".
[13 Nov 2010 16:20] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:41] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:alexander.nozdrin@oracle.com-20101113152540-gxro4g0v29l27f5x) (pib:21)
[16 Dec 2010 22:34] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)
[6 Jan 2011 16:40] Paul Dubois
Noted in 5.5.8 changelog.

The following words are no longer reserved words the way they are in
earlier MySQL 5.5 releases: SLOW, GENERAL, IGNORE_SERVER_IDS,
MASTER_HEARTBEAT_PERIOD