MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
partition_date_range.inc
1 # Created for verifying bug#20577.
2 # expects TABLE t1 (... , a DATE, ...)
3 
4 --sorted_result
5 SELECT * FROM t1 WHERE a < '1001-01-01';
6 --sorted_result
7 SELECT * FROM t1 WHERE a <= '1001-01-01';
8 --sorted_result
9 SELECT * FROM t1 WHERE a >= '1001-01-01';
10 --sorted_result
11 SELECT * FROM t1 WHERE a > '1001-01-01';
12 --sorted_result
13 SELECT * FROM t1 WHERE a = '1001-01-01';
14 --sorted_result
15 SELECT * FROM t1 WHERE a < '1001-00-00';
16 --sorted_result
17 SELECT * FROM t1 WHERE a <= '1001-00-00';
18 --sorted_result
19 SELECT * FROM t1 WHERE a >= '1001-00-00';
20 --sorted_result
21 SELECT * FROM t1 WHERE a > '1001-00-00';
22 --sorted_result
23 SELECT * FROM t1 WHERE a = '1001-00-00';
24 --echo # Disabling warnings for the invalid date
25 --disable_warnings
26 --sorted_result
27 SELECT * FROM t1 WHERE a < '1999-02-31';
28 --sorted_result
29 SELECT * FROM t1 WHERE a <= '1999-02-31';
30 --sorted_result
31 SELECT * FROM t1 WHERE a >= '1999-02-31';
32 --sorted_result
33 SELECT * FROM t1 WHERE a > '1999-02-31';
34 --sorted_result
35 SELECT * FROM t1 WHERE a = '1999-02-31';
36 --enable_warnings
37 --sorted_result
38 SELECT * FROM t1 WHERE a BETWEEN '0000-00-00' AND '1002-00-00';
39 --sorted_result
40 SELECT * FROM t1 WHERE a BETWEEN '0000-00-00' AND '1001-01-01';
41 --sorted_result
42 SELECT * FROM t1 WHERE a BETWEEN '0001-01-02' AND '1002-00-00';
43 --sorted_result
44 SELECT * FROM t1 WHERE a BETWEEN '0001-01-01' AND '1001-01-01';
45 if ($explain_partitions)
46 {
47 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1001-01-01';
48 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a <= '1001-01-01';
49 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a >= '1001-01-01';
50 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a > '1001-01-01';
51 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1001-01-01';
52 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1001-00-00';
53 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a <= '1001-00-00';
54 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a >= '1001-00-00';
55 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a > '1001-00-00';
56 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1001-00-00';
57 --echo # Disabling warnings for the invalid date
58 --disable_warnings
59 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1999-02-31';
60 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a <= '1999-02-31';
61 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a >= '1999-02-31';
62 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a > '1999-02-31';
63 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1999-02-31';
64 --enable_warnings
65 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a BETWEEN '0000-00-00' AND '1002-00-00';
66 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a BETWEEN '0000-00-00' AND '1001-01-01';
67 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a BETWEEN '0001-01-02' AND '1002-00-00';
68 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a BETWEEN '0001-01-01' AND '1001-01-01';
69 }