116 lines
5.7 KiB
Plaintext
116 lines
5.7 KiB
Plaintext
drop table if exists t;
|
|
create table t(a bigint(20) auto_increment primary key);
|
|
split table t between (-9223372036854775808) and (9223372036854775807) regions 16;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
15 1
|
|
drop table if exists t;
|
|
create table t(a int(20) auto_increment primary key);
|
|
split table t between (-9223372036854775808) and (9223372036854775807) regions 16;
|
|
Error 1690 (22003): constant -9223372036854775808 overflows int
|
|
drop table if exists t;
|
|
drop table if exists t, t1;
|
|
create table t(a varchar(100),b int, index idx1(b,a));
|
|
split table t index idx1 by (10000,"abcd"),(10000000);
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
3 1
|
|
split table t index idx1 by ("abcd");
|
|
Error 1265 (01000): Incorrect value: 'abcd' for column 'b'
|
|
split table t index idx1 between (0) and (1000000000) regions 10;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
9 1
|
|
split table t index idx1 between (2,'a') and (1,'c') regions 10;
|
|
Error 8212 (HY000): Failed to split region ranges: Split index `idx1` region lower value (2,a) should less than the upper value (1,c)
|
|
split table t index idx1 between () and (1) regions 10;
|
|
Error 1105 (HY000): Split index `idx1` region lower value count should more than 0
|
|
split table t index idx1 between (1) and () regions 10;
|
|
Error 1105 (HY000): Split index `idx1` region upper value count should more than 0
|
|
split table t index idx1 between (0) and (1000000000) regions 10000;
|
|
Error 1105 (HY000): Split index region num exceeded the limit 1000
|
|
split table t index idx1 between (0) and (1000000000) regions 0;
|
|
Error 1105 (HY000): Split index region num should more than 0
|
|
split table t index idx1 between ("aa") and (1000000000) regions 0;
|
|
Error 1265 (01000): Incorrect value: 'aa' for column 'b'
|
|
split table t between (0) and (1000000000) regions 10;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
10 1
|
|
split table t between (2) and (1) regions 10;
|
|
Error 8212 (HY000): Failed to split region ranges: lower value 2 should less than the upper value 1
|
|
split table t between () and (1) regions 10;
|
|
Error 1105 (HY000): Split table region lower value count should be 1
|
|
split table t between (1) and () regions 10;
|
|
Error 1105 (HY000): Split table region upper value count should be 1
|
|
split table t between (0) and (1000000000) regions 10000;
|
|
Error 1105 (HY000): Split table region num exceeded the limit 1000
|
|
split table t between (0) and (1000000000) regions 0;
|
|
Error 1105 (HY000): Split table region num should more than 0
|
|
split table t between ("aa") and (1000000000) regions 10;
|
|
Error 1265 (01000): Incorrect value: 'aa' for column '_tidb_rowid'
|
|
split table t between (0) and (100) regions 10;
|
|
Error 8212 (HY000): Failed to split region ranges: the region size is too small, expected at least 1000, but got 10
|
|
split table t by (0),(1000),(1000000);
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
3 1
|
|
create table t1(a int, b int);
|
|
split table t1 between(0) and (10000) regions 10;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
9 1
|
|
split table t1 between(10) and (10010) regions 5;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
4 1
|
|
drop table if exists t;
|
|
create table t (a int,b int) partition by hash(a) partitions 5;
|
|
split table t between (0) and (1000000) regions 5;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
20 1
|
|
split region for partition table t between (1000000) and (100000000) regions 10;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
45 1
|
|
split table t partition (p1,p2) between (100000000) and (1000000000) regions 5;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
8 1
|
|
split region for partition table t partition (p3,p4) between (100000000) and (1000000000) regions 5;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
8 1
|
|
set tidb_enable_clustered_index=ON;
|
|
drop table if exists t;
|
|
create table t (a varchar(255), b double, c int, primary key (a, b));
|
|
split table t between ('aaa') and ('aaa', 100.0) regions 10;
|
|
Error 1105 (HY000): Split table region lower value count should be 2
|
|
split table t between ('aaa', 1.0) and ('aaa', 100.0, 11) regions 10;
|
|
Error 1105 (HY000): Split table region upper value count should be 2
|
|
split table t between ('aaa', 0.0) and (100.0, 'aaa') regions 10;
|
|
Error 1265 (01000): Incorrect value: 'aaa' for column 'b'
|
|
split table t between ('aaa', 0.0) and ('aaa', 0.0) regions 10;
|
|
Error 8212 (HY000): Failed to split region ranges: Split table `t` region lower value (aaa,0) should less than the upper value (aaa,0)
|
|
split table t between ('bbb', 0.0) and ('aaa', 0.0) regions 10;
|
|
Error 8212 (HY000): Failed to split region ranges: Split table `t` region lower value (bbb,0) should less than the upper value (aaa,0)
|
|
split table t between ('aaa', 0.0) and ('aaa', 0.1) regions 100000;
|
|
Error 1105 (HY000): Split table region num exceeded the limit 1000
|
|
split table t between (null, null) and (null, null) regions 1000;
|
|
Error 1048 (23000): Column 'a' cannot be null
|
|
split table t by (null, null);
|
|
Error 1048 (23000): Column 'a' cannot be null
|
|
split table t between ('aaa', 0.0) and ('aaa', 100.0) regions 10;
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
9 1
|
|
split table t by ('aaa', 0.0), ('aaa', 20.0), ('aaa', 100.0);
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
3 1
|
|
split table t by ('aaa', 100.0), ('qqq', 20.0), ('zzz', 100.0), ('zzz', 1000.0);
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
3 1
|
|
drop table t;
|
|
create table t (a int, b int, c int, d int, primary key(d, a, c));
|
|
split table t by (0, 0, 0), (1, 2, 3), (65535, 65535, 65535);
|
|
TOTAL_SPLIT_REGION SCATTER_FINISH_RATIO
|
|
3 1
|
|
drop table if exists t;
|
|
create table t (a varchar(255), b decimal, c int, primary key (a, b));
|
|
split table t by ('aaa', '');
|
|
Error 1265 (01000): Incorrect value: '' for column 'b'
|
|
drop table t;
|
|
CREATE TABLE t (`id` varchar(10) NOT NULL, primary key (`id`) CLUSTERED);
|
|
split table t index `primary` between (0) and (1000) regions 2;
|
|
Error 1176 (42000): unable to split clustered index, please split table instead.
|
|
set tidb_enable_clustered_index=default;
|