• Luis Soares's avatar
    BUG#57899: Certain reserved words should not be reserved · 1602ffb8
    Luis Soares authored
    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.
    1602ffb8
keywords.test 5.42 KB