diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/create_no_primary_key_table.test')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/create_no_primary_key_table.test | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/create_no_primary_key_table.test b/storage/rocksdb/mysql-test/rocksdb/t/create_no_primary_key_table.test new file mode 100644 index 00000000000..c5650359d8c --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/create_no_primary_key_table.test @@ -0,0 +1,44 @@ +USE mysql; +CREATE TABLE mysql_table (a INT) ENGINE=ROCKSDB; +-- error ER_BLOCK_NO_PRIMARY_KEY +CREATE TABLE test.mysql_table (a INT) ENGINE=ROCKSDB; +USE test; +-- error ER_BLOCK_NO_PRIMARY_KEY +CREATE TABLE mysql_table (a INT) ENGINE=ROCKSDB; +-- error ER_BLOCK_NO_PRIMARY_KEY +CREATE TABLE IF NOT EXISTS mysql_table_2 (a INT) ENGINE=ROCKSDB; +-- error ER_BLOCK_NO_PRIMARY_KEY +CREATE TABLE mysql_table_no_cols ENGINE=ROCKSDB; +CREATE TABLE mysql.mysql_table_2 (a INT) ENGINE=ROCKSDB; + +CREATE TABLE mysql_primkey (a INT PRIMARY KEY, b INT, c INT, d INT, INDEX (c)) ENGINE=ROCKSDB; +ALTER TABLE mysql_primkey DROP b, DROP a, ADD (f INT PRIMARY KEY); +-- error ER_BLOCK_NO_PRIMARY_KEY +ALTER TABLE mysql_primkey DROP PRIMARY KEY; + +CREATE TABLE mysql_primkey2 (a INT PRIMARY KEY, b INT, c INT) ENGINE=ROCKSDB; +ALTER TABLE mysql_primkey2 DROP b; +ALTER TABLE mysql_primkey2 ADD (b INT); +-- error ER_BLOCK_NO_PRIMARY_KEY +ALTER TABLE mysql_primkey2 DROP c, DROP A; + +CREATE TABLE mysql_primkey3 (a INT PRIMARY KEY, b INT, c INT, INDEX indexonb (b), INDEX indexonc (c)) ENGINE=ROCKSDB; +ALTER TABLE mysql_primkey3 DROP INDEX indexonb; +ALTER TABLE mysql_primkey3 DROP c; +ALTER TABLE mysql_primkey3 DROP PRIMARY KEY, ADD PRIMARY KEY(b); + +CREATE TABLE mysql_primkey4(a INT, b INT, PRIMARY KEY(a), INDEX si (a, b)) ENGINE=ROCKSDB; +DROP INDEX si ON mysql_primkey4; +-- error ER_BLOCK_NO_PRIMARY_KEY +DROP INDEX `PRIMARY` ON mysql_primkey4; + +ALTER TABLE mysql.mysql_table ADD PRIMARY KEY (a); +ALTER TABLE mysql.mysql_table DROP PRIMARY KEY; + +DROP TABLE mysql_primkey; +DROP TABLE mysql_primkey2; +DROP TABLE mysql_primkey3; +DROP TABLE mysql_primkey4; +USE mysql; +DROP TABLE mysql_table; +DROP TABLE mysql_table_2; |