[MDEV-32795] ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note Created: 2023-11-13  Updated: 2023-12-13  Resolved: 2023-12-13

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Sequences
Affects Version/s: 10.4
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: sequences

Issue Links:
Problem/Incident
is caused by MDEV-10139 Support for SEQUENCE objects Closed
is caused by MDEV-13005 Fixing bugs in SEQUENCE, part 3 Closed

 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' |
 
+-------+------+----------------------------------



 Comments   
Comment by Daniel Black [ 2023-11-13 ]

rucha174 can you please review https://github.com/MariaDB/server/pull/2837

Generated at Thu Feb 08 10:34:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.