Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-19476

sql_mode="oracle" errors on create procedure AS... ORDER/NOORDER

Details

    Description

      CREATE SEQUENCE "SQ_TEST1" MINVALUE 1 INCREMENT BY 1 START WITH 1 NOORDER NOCYCLE ;

      This statement fails due to NOORDER not being recognized by MariaDB. ORDER is also not allowed as a attribute of CREATE SEQUENCE.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          austinrutherford Austin Rutherford (Inactive) created issue -
          ralf.gebhardt Ralf Gebhardt made changes -
          Field Original Value New Value
          Labels Compatibility
          bar Alexander Barkov added a comment - - edited

          austinrutherford,manjot, is the idea just to recognize the ORDER and NOORDER optional keywords and ignore them?

          monty In MariaDB sequences are always ORDER. Can you confirm please?

          bar Alexander Barkov added a comment - - edited austinrutherford , manjot , is the idea just to recognize the ORDER and NOORDER optional keywords and ignore them? monty In MariaDB sequences are always ORDER. Can you confirm please?
          bar Alexander Barkov made changes -
          Component/s Parser [ 10201 ]
          Component/s Sequences [ 14009 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 96737 ] MariaDB v4 [ 141292 ]

          People

            Unassigned Unassigned
            austinrutherford Austin Rutherford (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.