Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3(EOL)
-
None
Description
temporary sequences don't work properly after 'ALTER engine' command, e.g.:
MariaDB [test]> create temporary sequence s; |
Query OK, 0 rows affected (0.00 sec) |
|
MariaDB [test]> alter table s engine myisam; |
Query OK, 1 row affected (0.00 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> select nextval(s); |
+-----------------+ |
| nextval(s) |
|
+-----------------+ |
| 140241957546134 |
|
+-----------------+ |
1 row in set (0.00 sec) |
|
MariaDB [test]> \r
|
Connection id: 16 |
Current database: test |
|
MariaDB [test]> create temporary sequence s; |
Query OK, 0 rows affected (0.00 sec) |
|
MariaDB [test]> alter table s engine innodb; |
Query OK, 1 row affected (0.00 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> select nextval(s); |
+------------+ |
| nextval(s) |
|
+------------+ |
| 0 |
|
+------------+ |
1 row in set (0.00 sec) |
|
MariaDB [test]> select nextval(s); |
+-----------------+ |
| nextval(s) |
|
+-----------------+ |
| 140241957547216 |
|
+-----------------+ |
1 row in set (0.00 sec) |
Attachments
Issue Links
- relates to
-
MDEV-12930 Testing SEQUENCE object
- Closed