Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10764 PL/SQL parser - Phase 2
  3. MDEV-10485

"Unreserve" MariaDB reserved keywords that are not reserved in the other databases



    • Technical task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Parser
    • None


      MariaDB has a number of unnecessarily reserved keywords that are not reserved neither in the SQL standard nor in the other databases. This makes migration to MariaDB harder, as the DBA has to rename tables, columns and other objects.

      LOCALTIMESTAMP is an example.

      This query:

      CREATE TABLE localtimestamp (a INT);

      works without problems in Oracle, but returns an error in MariaDB:

      ERROR 1064 (42000): You have an error in your SQL syntax...near 'localtimestamp ... 

      Under terms of this tasks, we'll find all keywords that are reserved in MariaDB but not reserved in the other databases and try to "unreserve" those that do not really have to be reserved.


        1. keywords_alias_mdb.sql
          133 kB
          Jérôme Brauge
        2. keywords_alias_ora.sql
          133 kB
          Jérôme Brauge
        3. keywords_label_mdb.sql
          238 kB
          Jérôme Brauge
        4. keywords_label_ora.sql
          253 kB
          Jérôme Brauge
        5. keywords_var_mdb.sql
          228 kB
          Jérôme Brauge
        6. keywords_var_ora.sql
          254 kB
          Jérôme Brauge
        7. keywords.xlsx
          51 kB
          Jérôme Brauge

        Issue Links



              Unassigned Unassigned
              bar Alexander Barkov
              3 Vote for this issue
              5 Start watching this issue



                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.