Skip to content
  • Dyre Tjeldvoll's avatar
    1a717ec7
    WL#8972: Rename a general tablespace · 1a717ec7
    Dyre Tjeldvoll authored
    Extends the syntax for the ALTER TABLESPACE statement with the
    sub-command RENAME TO, so the general tablespaces can be renamed.
    
    Since this is the first in a seqence of planned extensions to
    tablespace syntax, it also includes a complete refactoring of the
    parser and executor code for TABLESPACE and LOGFILE group statements.
    
    The behavior of existing statements is intact, with the following exceptions:
    
     - ENGINE option is unnecessary and deprecated for DROP and ALTER
       TABLESPACE (for CREATE it is still required unless the default SE is
       desired)
    
     - The following undocumented, unimplemented tablespace-related syntax
       is removed (approved by NDB reviewer):
    
       ALTER TABLESPACE ... CHANGE DATAFILE ...
       ALTER TABLESPACE ... (READ_ONLY|READ_WRITE|NOT ACCESSIBLE)
       ALTER LOGFILE GROUP ... ADD REDOFILE ...
    
     - Some error conditions produce a different error since tablepaces now
       must be located in the DD earlier than
       before. E.g. ER_TABLESPACE_MISSING_WITH_NAME rather than
       ER_ILLEGAL_HA_CREATE_OPTION
    1a717ec7
    WL#8972: Rename a general tablespace
    Dyre Tjeldvoll authored
    Extends the syntax for the ALTER TABLESPACE statement with the
    sub-command RENAME TO, so the general tablespaces can be renamed.
    
    Since this is the first in a seqence of planned extensions to
    tablespace syntax, it also includes a complete refactoring of the
    parser and executor code for TABLESPACE and LOGFILE group statements.
    
    The behavior of existing statements is intact, with the following exceptions:
    
     - ENGINE option is unnecessary and deprecated for DROP and ALTER
       TABLESPACE (for CREATE it is still required unless the default SE is
       desired)
    
     - The following undocumented, unimplemented tablespace-related syntax
       is removed (approved by NDB reviewer):
    
       ALTER TABLESPACE ... CHANGE DATAFILE ...
       ALTER TABLESPACE ... (READ_ONLY|READ_WRITE|NOT ACCESSIBLE)
       ALTER LOGFILE GROUP ... ADD REDOFILE ...
    
     - Some error conditions produce a different error since tablepaces now
       must be located in the DD earlier than
       before. E.g. ER_TABLESPACE_MISSING_WITH_NAME rather than
       ER_ILLEGAL_HA_CREATE_OPTION
Loading