57
57
1 SIMPLE t1 pnull system NULL NULL NULL NULL 1
58
58
explain partitions select * from t1 where a >= 0;
59
59
id select_type table partitions type possible_keys key key_len ref rows Extra
60
1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 2 Using where
60
1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 3 Using where
61
61
explain partitions select * from t1 where a < 0;
62
62
id select_type table partitions type possible_keys key key_len ref rows Extra
63
63
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
64
64
explain partitions select * from t1 where a <= 0;
65
65
id select_type table partitions type possible_keys key key_len ref rows Extra
66
1 SIMPLE t1 pnull,p0 ALL NULL NULL NULL NULL 2 Using where
66
1 SIMPLE t1 pnull,p0 ALL NULL NULL NULL NULL 3 Using where
67
67
explain partitions select * from t1 where a > 1;
68
68
id select_type table partitions type possible_keys key key_len ref rows Extra
69
69
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
97
97
explain partitions select * from t1 where a is null;
98
98
id select_type table partitions type possible_keys key key_len ref rows Extra
99
1 SIMPLE t1 pnull_pnullsp0,pnull_pnullsp1 ALL NULL NULL NULL NULL 2 Using where
99
1 SIMPLE t1 pnull_pnullsp0,pnull_pnullsp1 ALL NULL NULL NULL NULL 6 Using where
100
100
explain partitions select * from t1 where a >= 0;
101
101
id select_type table partitions type possible_keys key key_len ref rows Extra
102
1 SIMPLE t1 p0_p0sp0,p0_p0sp1,p1_p1sp0,p1_p1sp1 ALL NULL NULL NULL NULL 4 Using where
102
1 SIMPLE t1 p0_p0sp0,p0_p0sp1,p1_p1sp0,p1_p1sp1 ALL NULL NULL NULL NULL 6 Using where
103
103
explain partitions select * from t1 where a < 0;
104
104
id select_type table partitions type possible_keys key key_len ref rows Extra
105
1 SIMPLE t1 pnull_pnullsp0,pnull_pnullsp1 ALL NULL NULL NULL NULL 2 Using where
105
1 SIMPLE t1 pnull_pnullsp0,pnull_pnullsp1 ALL NULL NULL NULL NULL 6 Using where
106
106
explain partitions select * from t1 where a <= 0;
107
107
id select_type table partitions type possible_keys key key_len ref rows Extra
108
1 SIMPLE t1 pnull_pnullsp0,pnull_pnullsp1,p0_p0sp0,p0_p0sp1 ALL NULL NULL NULL NULL 4 Using where
108
1 SIMPLE t1 pnull_pnullsp0,pnull_pnullsp1,p0_p0sp0,p0_p0sp1 ALL NULL NULL NULL NULL 6 Using where
109
109
explain partitions select * from t1 where a > 1;
110
110
id select_type table partitions type possible_keys key key_len ref rows Extra
111
111
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables