| 1 |
--source include/galera_cluster.inc |
| 2 |
--source include/have_sequence.inc |
| 3 |
|
| 4 |
CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BINARY (10), c3 DATETIME); |
| 5 |
SELECT get_lock ('test2', 0); |
| 6 |
DROP TABLE t1; |
| 7 |
CREATE TABLE t1 (c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY); |
| 8 |
INSERT INTO t1 VALUES (1); |
| 9 |
SET SESSION wsrep_trx_fragment_size=10; |
| 10 |
SET SESSION autocommit=0; |
| 11 |
SELECT * FROM t1 WHERE c1 <=0 ORDER BY c1 DESC; |
| 12 |
--error ER_LOCK_DEADLOCK |
| 13 |
INSERT INTO t1 VALUES (4),(3),(1),(2); |
| 14 |
# |
| 15 |
# This is because support for CREATE TABLE ENGINE=SEQUENCE |
| 16 |
# is done before we check does table exists already. |
| 17 |
# |
| 18 |
--error ER_NOT_SUPPORTED_YET |
| 19 |
CREATE TABLE t1 (pk INT PRIMARY KEY, b INT) ENGINE=SEQUENCE; |
| 20 |
--error ER_CANT_DROP_FIELD_OR_KEY |
| 21 |
ALTER TABLE t1 DROP COLUMN c2; |
| 22 |
SELECT get_lock ('test', 1.5); |
| 23 |
DROP TABLE t1; |