mysql-test/main/func_extract.result

6 EXTRACT(DAY FROM t),
11 EXTRACT(DAY FROM d),
16 EXTRACT(DAY FROM v),
21 EXTRACT(DAY FROM ll),
30   `EXTRACT(DAY FROM t)` int(3) DEFAULT NULL,
35   `EXTRACT(DAY FROM d)` int(3) DEFAULT NULL,
40   `EXTRACT(DAY FROM v)` int(8) DEFAULT NULL,
45   `EXTRACT(DAY FROM ll)` int(8) DEFAULT NULL,
77 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
78 a	b	EXTRACT(DAY FROM a)	EXTRACT(DAY FROM b)
91 EXTRACT(DAY FROM a) * 24 + EXTRACT(HOUR FROM a) AS dh,
93 EXTRACT(DAY FROM a),
99 a	cidm	dh	EXTRACT(DAY_HOUR FROM a)	EXTRACT(DAY FROM a)	EXTRACT(HOUR FROM a)	EXTRACT(MINUTE FROM a)	…
118 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '9999-12-31 23:59:59.123456'
119 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '2001-01-01 10:20:30.123456'
120 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '4294967296:59:59.123456'
129 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '4294967295:59:59.123456'
138 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '87649416:59:59.123456'
150 EXTRACT(DAY FROM b) * 24 + EXTRACT(HOUR FROM b) AS dh,
152 EXTRACT(DAY FROM b),
158 b	cidm	dh	EXTRACT(DAY_HOUR FROM b)	EXTRACT(DAY FROM b)	EXTRACT(HOUR FROM b)	EXTRACT(MINUTE FROM b)	…
177 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '99991231235959.123456000'
178 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '20010101102030.123456000'
179 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '42949672965959.123456000'
188 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '42949672955959.123456000'
197 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '876494165959.123456000'
206 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '876494155959.123456000'
207 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '876494145959.123456000'
208 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '99995959.123456000'
209 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '99990101.123456000'
210 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '99990101.000000000'
211 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.999999000'
212 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.999990000'
213 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.999900000'
214 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.999000000'
215 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.990000000'
216 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.900000000'
217 Note	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '0.000000000'
219 # Special case: DAY + TIME
227 EXTRACT(DAY FROM a),
233 …FROM a)	EXTRACT(DAY_SECOND FROM a)	EXTRACT(DAY_MICROSECOND FROM a)	EXTRACT(DAY FROM a)	EXTRACT(HOU…
245 EXTRACT(DAY FROM a),
251 …FROM a)	EXTRACT(DAY_SECOND FROM a)	EXTRACT(DAY_MICROSECOND FROM a)	EXTRACT(DAY FROM a)	EXTRACT(HOU…
254 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: ''
273 SELECT EXTRACT(DAY   FROM '2001/02/03 10:20:30');
274 EXTRACT(DAY   FROM '2001/02/03 10:20:30')
282 SELECT EXTRACT(DAY   FROM '01/02/03 10:20:30');
283 EXTRACT(DAY   FROM '01/02/03 10:20:30')
291 SELECT EXTRACT(DAY   FROM '01:02:03 10:20:30');
292 EXTRACT(DAY   FROM '01:02:03 10:20:30')
305 SELECT EXTRACT(DAY   FROM "2011-02-32 8:46:06.23434");
306 EXTRACT(DAY   FROM "2011-02-32 8:46:06.23434")
322 SELECT EXTRACT(DAY   FROM '2001/02/03');
323 EXTRACT(DAY   FROM '2001/02/03')
331 SELECT EXTRACT(DAY   FROM '01/02/03');
332 EXTRACT(DAY   FROM '01/02/03')
340 SELECT EXTRACT(DAY   FROM '01-02-03');
341 EXTRACT(DAY   FROM '01-02-03')
349 SELECT EXTRACT(DAY   FROM '1-2-3');
350 EXTRACT(DAY   FROM '1-2-3')
355 SELECT EXTRACT(DAY FROM '2024-01-03 garbage /////');
356 EXTRACT(DAY FROM '2024-01-03 garbage /////')
360 SELECT EXTRACT(DAY FROM '24-01-03 garbage /////');
361 EXTRACT(DAY FROM '24-01-03 garbage /////')
365 SELECT EXTRACT(DAY FROM '01-02-03');
366 EXTRACT(DAY FROM '01-02-03')
368 SELECT EXTRACT(DAY FROM '24:02:03T');
369 EXTRACT(DAY FROM '24:02:03T')
371 SELECT EXTRACT(DAY FROM '24-02-03');
372 EXTRACT(DAY FROM '24-02-03')
374 SELECT EXTRACT(DAY FROM '24/02/03');
375 EXTRACT(DAY FROM '24/02/03')
377 SELECT EXTRACT(DAY FROM '11111');
378 EXTRACT(DAY FROM '11111')
389 SELECT EXTRACT(DAY FROM '2001-01-01T'), EXTRACT(DAY FROM '2001-01-01T ');
390 EXTRACT(DAY FROM '2001-01-01T')	EXTRACT(DAY FROM '2001-01-01T ')
392 SELECT EXTRACT(DAY FROM '2001/01/01T'), EXTRACT(DAY FROM '2001/01/01T ');
393 EXTRACT(DAY FROM '2001/01/01T')	EXTRACT(DAY FROM '2001/01/01T ')
395 SELECT EXTRACT(DAY FROM '2001:01:01T'), EXTRACT(DAY FROM '2001:01:01T ');
396 EXTRACT(DAY FROM '2001:01:01T')	EXTRACT(DAY FROM '2001:01:01T ')
411 SELECT EXTRACT(DAY FROM '100000:02:03T');
412 EXTRACT(DAY FROM '100000:02:03T')
416 SELECT EXTRACT(DAY FROM '100000/02/03');
417 EXTRACT(DAY FROM '100000/02/03')
421 SELECT EXTRACT(DAY FROM '100000-02-03');
422 EXTRACT(DAY FROM '100000-02-03')
426 SELECT EXTRACT(DAY FROM '1111');
427 EXTRACT(DAY FROM '1111')
431 SELECT EXTRACT(DAY FROM '111');
432 EXTRACT(DAY FROM '111')
436 SELECT EXTRACT(DAY FROM '11');
437 EXTRACT(DAY FROM '11')
441 SELECT EXTRACT(DAY FROM '1');
442 EXTRACT(DAY FROM '1')
503 # (behavior has changed for DAY, see below)
553 EXTRACT(DAY FROM a),
557 EXTRACT(DAY FROM a)	EXTRACT(DAY_SECOND FROM a)	a	cidm
573 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '2024:01:03 garbage /////'
576 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '24:01:03 garbage /////'
579 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '01:01:03 garbage /////'
582 Warning	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '01:02:03:'
585 Warning	1292	Incorrect INTERVAL DAY TO SECOND value: '01:02:03-'
588 Warning	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '01:02:03;'
591 Warning	1292	Truncated incorrect INTERVAL DAY TO SECOND value: '01:02:03/'