Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19477

sql_mode="oracle" errors on create procedure AS ... MAXVALUE

Details

    Description

      CREATE SEQUENCE "SQ_TEST2" MINVALUE 1 MAXVALUE 99999999999999999 INCREMENT BY 1;

      The MAXVALUE in this case causes error in MariaDB Server with Oracle Compatibility mode - it works in ORACLE.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          ralf.gebhardt Ralf Gebhardt added a comment -

          austinrutherford I have tried it with 10.4.6 and could not see an issue. Can you test it again?

          ralf.gebhardt Ralf Gebhardt added a comment - austinrutherford I have tried it with 10.4.6 and could not see an issue. Can you test it again?
          bar Alexander Barkov added a comment -

          manjot, austinrutherford,
          This seems to work fine:

          SET sql_mode=ORACLE;
          		 
          CREATE SEQUENCE "SQ_TEST2" MINVALUE 1 MAXVALUE 99999999999999999 INCREMENT BY 1;

          Can we close this issue?

          bar Alexander Barkov added a comment - manjot , austinrutherford , This seems to work fine: SET sql_mode=ORACLE; CREATE SEQUENCE "SQ_TEST2" MINVALUE 1 MAXVALUE 99999999999999999 INCREMENT BY 1; Can we close this issue?
          manjot Manjot Singh (Inactive) added a comment -

          What is the fix version? Is it documented?

          Thanks,
          Manjot Singh
          Lead Enterprise Architect
          MariaDB Corporation | t: +1 (408) 899-9907

          On Mon, Sep 9, 2019, 8:08 PM Alexander Barkov (Jira) <jira@mariadb.org>

          manjot Manjot Singh (Inactive) added a comment - What is the fix version? Is it documented? Thanks, Manjot Singh Lead Enterprise Architect MariaDB Corporation | t: +1 (408) 899-9907 On Mon, Sep 9, 2019, 8:08 PM Alexander Barkov (Jira) <jira@mariadb.org>
          bar Alexander Barkov added a comment - - edited

          manjot I think it worked from the very beginning, when CREATE SEQUENCE was introduced.
          Can we close the issue?

          bar Alexander Barkov added a comment - - edited manjot I think it worked from the very beginning, when CREATE SEQUENCE was introduced. Can we close the issue?
          manjot Manjot Singh (Inactive) added a comment -

          The test version I used (I believe 10.3.8) didn't support it as you can see
          in the ticket.

          manjot Manjot Singh (Inactive) added a comment - The test version I used (I believe 10.3.8) didn't support it as you can see in the ticket.

          People

            Unassigned Unassigned
            austinrutherford Austin Rutherford (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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