81 lines
2.6 KiB
Plaintext
81 lines
2.6 KiB
Plaintext
# TestAlterPartitionCache
|
|
drop table if exists cache_partition_table;
|
|
create table cache_partition_table (a int, b int) partition by hash(a) partitions 3;
|
|
-- error 8242
|
|
alter table cache_partition_table cache;
|
|
drop table if exists cache_partition_range_table;
|
|
create table cache_partition_range_table (c1 smallint(6) not null, c2 char(5) default null) partition by range ( c1 ) (
|
|
partition p0 values less than (10),
|
|
partition p1 values less than (20),
|
|
partition p2 values less than (30),
|
|
partition p3 values less than (MAXVALUE)
|
|
);
|
|
-- error 8242
|
|
alter table cache_partition_range_table cache;
|
|
drop table if exists partition_list_table;
|
|
create table cache_partition_list_table (id int) partition by list (id) (
|
|
partition p0 values in (1,2),
|
|
partition p1 values in (3,4),
|
|
partition p3 values in (5,null)
|
|
);
|
|
-- error 8242
|
|
alter table cache_partition_list_table cache;
|
|
drop table if exists cache_partition_list_table;
|
|
drop table if exists cache_partition_range_table;
|
|
drop table if exists cache_partition_table;
|
|
|
|
# TestAlterViewTableCache
|
|
drop table if exists cache_view_t;
|
|
create table cache_view_t (id int);
|
|
create view v as select * from cache_view_t;
|
|
-- error 1347
|
|
alter table v cache;
|
|
drop view v;
|
|
|
|
# TestAlterTableNoCache
|
|
drop table if exists nocache_t1;
|
|
create table nocache_t1 ( n int auto_increment primary key);
|
|
alter table nocache_t1 cache;
|
|
show create table nocache_t1;
|
|
alter table nocache_t1 nocache;
|
|
show create table nocache_t1;
|
|
drop table if exists t1;
|
|
drop table if exists nocache_t;
|
|
-- error 1146
|
|
alter table nocache_t cache;
|
|
create table nocache_t (a int);
|
|
alter table nocache_t nocache;
|
|
# Multiple no alter cache is okay
|
|
alter table nocache_t nocache;
|
|
alter table nocache_t nocache;
|
|
|
|
# TestIndexOnCacheTable
|
|
drop table if exists cache_index;
|
|
create table cache_index (c1 int primary key, c2 int, c3 int, index ok2(c2));
|
|
alter table cache_index cache;
|
|
-- error 8242
|
|
create index cache_c2 on cache_index(c2);
|
|
-- error 8242
|
|
alter table cache_index add index k2(c2);
|
|
-- error 8242
|
|
alter table cache_index drop index ok2;
|
|
-- error 8242
|
|
alter table cache_index rename index ok2 to ok;
|
|
drop table if exists cache_index_1;
|
|
create table cache_index_1 (id int, c1 int, c2 int, primary key(id), key i1(c1), key i2(c2));
|
|
alter table cache_index_1 cache;
|
|
-- error 8242
|
|
alter table cache_index_1 drop index i1, drop index i2;
|
|
alter table cache_index_1 nocache;
|
|
alter table cache_index nocache;
|
|
drop table if exists cache_index;
|
|
|
|
# TestIssue32692
|
|
drop table if exists cache_t2;
|
|
create table cache_t2 (c1 int);
|
|
alter table cache_t2 cache;
|
|
alter table cache_t2 nocache;
|
|
alter table cache_t2 cache;
|
|
show warnings;
|
|
|