Details
Description
In the following case, statements 1 and 2 succeed, so is statement 3, but statement 4 fails. It should succeed because 2 succeeds.
|
11.4 3fad2b115569864d8c1b7ea90ce92aa895cfef08 |
create sequence s; |
/* 1 */ alter sequence s maxvalue 123; |
/* 2 */ alter sequence s maxvalue 123; |
drop sequence s; |
 |
create sequence s; |
prepare stmt from 'alter sequence s maxvalue 123'; |
/* 3 */ execute stmt; |
/* 4 */ execute stmt; |
deallocate prepare stmt; |
drop sequence s; |
Could also reprod at 10.4 9695974e4b212aa4820e0ccfeb164f5444c0d58e.
The error is
mysqltest: At line 10: query '/* 4 */ execute stmt' failed: 4085: Sequence 'test.s' has out of range value for options
|
Attachments
Issue Links
- blocks
-
MDEV-33012 Alter sequence with second execution of prepare statement crashes server
-
- Closed
-