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

Details

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

    Description

      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.

      Attachments

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

        Issue Links

          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-11070 Providing compatibility to other databases - Phase 2

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-12518 Unify sql_yacc.yy and sql_yacc_ora.yy

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16244 sql_mode=ORACLE: Some keywords do not work in variable declarations

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16258 sql_mode=ORACLE: Keywords from keyword_verb_clause do not work in assignments

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16259 sql_mode=ORACLE: Keywords from keyword_sp_head do not work in assignments

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            Epic Link MDEV-10137 [ 56868 ]
            bar Alexander Barkov made changes -
            Description 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:
            {code:sql}
            CREATE TABLE localtimestamp (a INT);
            {code}
            works without problems in Oracle, but returns an error in MariaDB:
            {noformat}
            ERROR 1064 (42000): You have an error in your SQL syntax...near 'localtimestamp ...
            {noformat}

            Under terms of this tasks, we'll find all keywords that are reserved in MariaDB but not reserved in the other databases.
            		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:
            {code:sql}
            CREATE TABLE localtimestamp (a INT);
            {code}
            works without problems in Oracle, but returns an error in MariaDB:
            {noformat}
            ERROR 1064 (42000): You have an error in your SQL syntax...near 'localtimestamp ...
            {noformat}

            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.
            bar Alexander Barkov made changes -
            Affects Version/s 10.2 [ 14601 ]
            Issue Type Bug [ 1 ] Task [ 3 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            alvinr Alvin Richards (Inactive) made changes -
            alvinr Alvin Richards (Inactive) made changes -
            monty Michael Widenius made changes -
            Epic Link MDEV-10137 [ 56868 ]
            bar Alexander Barkov made changes -
            Parent MDEV-10764 [ 57940 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            halfspawn Jérôme Brauge made changes -
            Attachment keywords.xlsx [ 43422 ]
            Attachment keywords_alias_mdb.sql [ 43423 ]
            Attachment keywords_alias_ora.sql [ 43424 ]
            Attachment keywords_label_mdb.sql [ 43425 ]
            Attachment keywords_label_ora.sql [ 43426 ]
            Attachment keywords_var_mdb.sql [ 43427 ]
            Attachment keywords_var_ora.sql [ 43428 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Fix Version/s 10.3 [ 22126 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexander Barkov [ bar ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76560 ] MariaDB v4 [ 140028 ]

            People

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

              Dates

                Created:
                Updated:

                Git Integration

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