mysql-test/suite/galera/t/MDEV-37056.test
raw| 1 | --source include/galera_cluster.inc |
| 2 | |
| 3 | --connection node_1 |
| 4 | SET SESSION wsrep_on=OFF; |
| 5 | SET default_storage_engine=MYISAM; |
| 6 | CREATE SEQUENCE t; |
| 7 | SET SESSION wsrep_on=ON; |
| 8 | --error ER_SEQUENCE_INVALID_TABLE_STRUCTURE |
| 9 | CREATE INDEX idx ON t (a); |
| 10 | DROP SEQUENCE t; |
| 11 | |
| 12 | SET default_storage_engine='MYISAM'; |
| 13 | CREATE SEQUENCE t INCREMENT BY 0 CACHE=0 ENGINE=InnoDB; |
| 14 | --error ER_SEQUENCE_INVALID_TABLE_STRUCTURE |
| 15 | CREATE INDEX c ON t (c); |
| 16 | |
| 17 | # cleanup |
| 18 | DROP SEQUENCE t; |