69
69
1 SIMPLE t1 p0,p1,p2,p3 ALL NULL NULL NULL NULL 9 Using where
70
70
explain partitions select * from t1 where a is null or (a >= 5 and a <= 7);
71
71
id select_type table partitions type possible_keys key key_len ref rows Extra
72
1 SIMPLE t1 p0,p2,p3 ALL NULL NULL NULL NULL 7 Using where
72
1 SIMPLE t1 p0,p2,p3 ALL NULL NULL NULL NULL 9 Using where
73
73
explain partitions select * from t1 where a is null;
74
74
id select_type table partitions type possible_keys key key_len ref rows Extra
75
1 SIMPLE t1 p0 ALL NULL NULL NULL NULL 3 Using where
75
1 SIMPLE t1 p0 ALL NULL NULL NULL NULL 9 Using where
76
76
explain partitions select * from t1 where a is not null;
77
77
id select_type table partitions type possible_keys key key_len ref rows Extra
78
78
1 SIMPLE t1 p0,p1,p2,p3 ALL NULL NULL NULL NULL 9 Using where
79
79
explain partitions select * from t1 where a >= 1 and a < 3;
80
80
id select_type table partitions type possible_keys key key_len ref rows Extra
81
1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 5 Using where
81
1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 9 Using where
82
82
explain partitions select * from t1 where a >= 3 and a <= 5;
83
83
id select_type table partitions type possible_keys key key_len ref rows Extra
84
1 SIMPLE t1 p1,p2 ALL NULL NULL NULL NULL 4 Using where
84
1 SIMPLE t1 p1,p2 ALL NULL NULL NULL NULL 9 Using where
85
85
explain partitions select * from t1 where a > 2 and a < 4;
86
86
id select_type table partitions type possible_keys key key_len ref rows Extra
87
1 SIMPLE t1 p1 ALL NULL NULL NULL NULL 2 Using where
87
1 SIMPLE t1 p1 ALL NULL NULL NULL NULL 9 Using where
88
88
explain partitions select * from t1 where a > 3 and a <= 6;
89
89
id select_type table partitions type possible_keys key key_len ref rows Extra
90
1 SIMPLE t1 p2,p3 ALL NULL NULL NULL NULL 4 Using where
90
1 SIMPLE t1 p2,p3 ALL NULL NULL NULL NULL 9 Using where
91
91
explain partitions select * from t1 where a > 5;
92
92
id select_type table partitions type possible_keys key key_len ref rows Extra
93
93
1 SIMPLE t1 p0,p1,p2,p3 ALL NULL NULL NULL NULL 9 Using where