mirror of
https://github.com/MariaDB/server.git
synced 2025-01-15 19:42:28 +01:00
f03f4da663
Adding tests to cover how SEQUENCE related statements work in combination with the slow log configuration commands.
20 lines
479 B
SQL
20 lines
479 B
SQL
CREATE TABLE t1 (a INT);
|
|
CREATE INDEX t1a ON t1 (a);
|
|
DROP INDEX t1a ON t1;
|
|
DROP TABLE t1;
|
|
CREATE TABLE t2 (a INT);
|
|
ALTER TABLE t2 RENAME t2;
|
|
RENAME TABLE t2 TO t3;
|
|
DROP TABLE t3;
|
|
CREATE TABLE t4 (a INT);
|
|
PREPARE stmt FROM 'ALTER TABLE t4 MODIFY a INT DEFAULT 1';
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
DROP TABLE t4;
|
|
|
|
CREATE SEQUENCE s4;
|
|
ALTER SEQUENCE s4 MAXVALUE 100;
|
|
PREPARE stmt FROM 'ALTER SEQUENCE s4 MAXVALUE=101';
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
DROP SEQUENCE s4;
|