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

ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note

    XMLWordPrintable

Details

    Description

      reported by @marxide:

      https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/Alter.20sequence.20if.20exists

      Actual results:

      MariaDB [test]>  ALTER SEQUENCE IF EXISTS no_exists MINVALUE 10;
      ERROR 4091 (42S02): Unknown SEQUENCE: 'no_exists'
      MariaDB [test]>
      

      Expected results:

      MariaDB [test]>  ALTER SEQUENCE IF EXISTS no_exists MINVALUE 10;
      Query OK, 0 rows affected, 1 warning (0.001 sec)
       
      MariaDB [test]> show warnings;
      +-------+------+------------------------------------+
      | Level | Code | Message                            |
      +-------+------+------------------------------------+
      | Note  | 4091 | Unknown SEQUENCE: 'test.no_exists' |
      +-------+------+----------------------------------
      

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.