mysql-test/main/func_date_add.test

39 having mts < DATE_SUB(NOW(),INTERVAL 3 MONTH);
41 having DATE_ADD(mts,INTERVAL 3 MONTH) < NOW();
51 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
55 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
56 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
60 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
62 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
75 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 DAY;
76 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 MONTH;
77 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR;
78 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 WEEK;
108 --echo # MDEV-14452 Precision in INTERVAL xxx DAY_MICROSECOND parsed wrong?
113   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5' DAY_MICROSECOND) c1,
114   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50' DAY_MICROSECOND) c2,
115   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.500' DAY_MICROSECOND) c3,
116   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5000' DAY_MICROSECOND) c4,
117   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50000' DAY_MICROSECOND) c5,
118   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.500000' DAY_MICROSECOND) c6,
119   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5000000' DAY_MICROSECOND) c7,
120   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50000000' DAY_MICROSECOND) c8,
121   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.500000000' DAY_MICROSECOND) c9,
122   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5000000000' DAY_MICROSECOND) c10,
123   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50000000000' DAY_MICROSECOND) c11,
124   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.500000000000' DAY_MICROSECOND) c12,
125   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5000000000000' DAY_MICROSECOND) c13,
126   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50000000000000' DAY_MICROSECOND) c14,
127   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.500000000000000' DAY_MICROSECOND) c15,
128   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5000000000000000' DAY_MICROSECOND) c16,
129   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50000000000000000' DAY_MICROSECOND) c17,
130   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.500000000000000000' DAY_MICROSECOND) c18,
131   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.5000000000000000000' DAY_MICROSECOND) c19,
132   DATE_ADD('1000-01-01 00:00:00', INTERVAL '0 00:00:01.50000000000000000000' DAY_MICROSECOND) c20