Adding upstream version 1:10.5.12.upstream/1%10.5.12upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 749 insertions, 0 deletions

diff --git a/mysql-test/suite/engines/funcs/r/date_function.result b/mysql-test/suite/engines/funcs/r/date_function.result
new file mode 100644
index 00000000..3eea9330
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/r/date_function.result
@@ -0,0 +1,749 @@
+DROP TABLE IF EXISTS t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DATE(c1) FROM t3;
+DATE(c1)
+1000-01-01
+1999-12-31
+2000-01-01
+2006-12-25
+2008-02-29
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DATE(c1) FROM t3;
+DATE(c1)
+1000-01-01
+1999-12-31
+2000-01-01
+2006-12-25
+2008-02-29
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DATE(c1) FROM t3;
+DATE(c1)
+0000-00-00
+1999-12-31
+2000-01-01
+2006-12-25
+2008-02-29
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYNAME(c1) FROM t3;
+DAYNAME(c1)
+Wednesday
+Friday
+Saturday
+Monday
+Friday
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYNAME(c1) FROM t3;
+DAYNAME(c1)
+Wednesday
+Friday
+Saturday
+Monday
+Friday
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYNAME(c1) FROM t3;
+DAYNAME(c1)
+NULL
+Friday
+Saturday
+Monday
+Friday
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFMONTH(c1) FROM t3;
+DAYOFMONTH(c1)
+1
+31
+1
+25
+29
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFMONTH(c1) FROM t3;
+DAYOFMONTH(c1)
+1
+31
+1
+25
+29
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFMONTH(c1) FROM t3;
+DAYOFMONTH(c1)
+0
+31
+1
+25
+29
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFWEEK(c1) FROM t3;
+DAYOFWEEK(c1)
+4
+6
+7
+2
+6
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFWEEK(c1) FROM t3;
+DAYOFWEEK(c1)
+4
+6
+7
+2
+6
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFWEEK(c1) FROM t3;
+DAYOFWEEK(c1)
+NULL
+6
+7
+2
+6
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFYEAR(c1) FROM t3;
+DAYOFYEAR(c1)
+1
+365
+1
+359
+60
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFYEAR(c1) FROM t3;
+DAYOFYEAR(c1)
+1
+365
+1
+359
+60
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT DAYOFYEAR(c1) FROM t3;
+DAYOFYEAR(c1)
+NULL
+365
+1
+359
+60
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT FROM_DAYS(c1) FROM t3;
+FROM_DAYS(c1)
+0000-00-00
+0000-00-00
+0000-00-00
+0000-00-00
+0000-00-00
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT FROM_DAYS(c1) FROM t3;
+FROM_DAYS(c1)
+0000-00-00
+0000-00-00
+0000-00-00
+0000-00-00
+0000-00-00
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT FROM_DAYS(c1) FROM t3;
+FROM_DAYS(c1)
+0000-00-00
+0000-00-00
+0000-00-00
+0000-00-00
+0000-00-00
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT LAST_DAY(c1) FROM t3;
+LAST_DAY(c1)
+1000-01-31
+1999-12-31
+2000-01-31
+2006-12-31
+2008-02-29
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT LAST_DAY(c1) FROM t3;
+LAST_DAY(c1)
+1000-01-31
+1999-12-31
+2000-01-31
+2006-12-31
+2008-02-29
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT LAST_DAY(c1) FROM t3;
+LAST_DAY(c1)
+NULL
+1999-12-31
+2000-01-31
+2006-12-31
+2008-02-29
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT MONTH(c1) FROM t3;
+MONTH(c1)
+1
+12
+1
+12
+2
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT MONTH(c1) FROM t3;
+MONTH(c1)
+1
+12
+1
+12
+2
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT MONTH(c1) FROM t3;
+MONTH(c1)
+0
+12
+1
+12
+2
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT MONTHNAME(c1) FROM t3;
+MONTHNAME(c1)
+January
+December
+January
+December
+February
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT MONTHNAME(c1) FROM t3;
+MONTHNAME(c1)
+January
+December
+January
+December
+February
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT MONTHNAME(c1) FROM t3;
+MONTHNAME(c1)
+NULL
+December
+January
+December
+February
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT QUARTER(c1) FROM t3;
+QUARTER(c1)
+1
+4
+1
+4
+1
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT QUARTER(c1) FROM t3;
+QUARTER(c1)
+1
+4
+1
+4
+1
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT QUARTER(c1) FROM t3;
+QUARTER(c1)
+0
+4
+1
+4
+1
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT TIMESTAMP(c1) FROM t3;
+TIMESTAMP(c1)
+1000-01-01 00:00:00
+1999-12-31 00:00:00
+2000-01-01 00:00:00
+2006-12-25 00:00:00
+2008-02-29 00:00:00
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT TIMESTAMP(c1) FROM t3;
+TIMESTAMP(c1)
+1000-01-01 00:00:00
+1999-12-31 00:00:00
+2000-01-01 00:00:00
+2006-12-25 00:00:00
+2008-02-29 00:00:00
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT TIMESTAMP(c1) FROM t3;
+TIMESTAMP(c1)
+0000-00-00 00:00:00
+1999-12-31 00:00:00
+2000-01-01 00:00:00
+2006-12-25 00:00:00
+2008-02-29 00:00:00
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT TO_DAYS(c1) FROM t3;
+TO_DAYS(c1)
+365243
+730484
+730485
+733035
+733466
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT TO_DAYS(c1) FROM t3;
+TO_DAYS(c1)
+365243
+730484
+730485
+733035
+733466
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT TO_DAYS(c1) FROM t3;
+TO_DAYS(c1)
+NULL
+730484
+730485
+733035
+733466
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEK(c1) FROM t3;
+WEEK(c1)
+0
+52
+0
+52
+8
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEK(c1) FROM t3;
+WEEK(c1)
+0
+52
+0
+52
+8
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEK(c1) FROM t3;
+WEEK(c1)
+NULL
+52
+0
+52
+8
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEKDAY(c1) FROM t3;
+WEEKDAY(c1)
+2
+4
+5
+0
+4
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEKDAY(c1) FROM t3;
+WEEKDAY(c1)
+2
+4
+5
+0
+4
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEKDAY(c1) FROM t3;
+WEEKDAY(c1)
+NULL
+4
+5
+0
+4
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEKOFYEAR(c1) FROM t3;
+WEEKOFYEAR(c1)
+1
+52
+52
+52
+9
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEKOFYEAR(c1) FROM t3;
+WEEKOFYEAR(c1)
+1
+52
+52
+52
+9
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT WEEKOFYEAR(c1) FROM t3;
+WEEKOFYEAR(c1)
+NULL
+52
+52
+52
+9
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT YEAR(c1) FROM t3;
+YEAR(c1)
+1000
+1999
+2000
+2006
+2008
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT YEAR(c1) FROM t3;
+YEAR(c1)
+1000
+1999
+2000
+2006
+2008
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT YEAR(c1) FROM t3;
+YEAR(c1)
+0
+1999
+2000
+2006
+2008
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATE NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT YEARWEEK(c1) FROM t3;
+YEARWEEK(c1)
+99952
+199952
+199952
+200652
+200808
+DROP TABLE t3;
+CREATE TABLE t3(c1 DATETIME NOT NULL);
+INSERT INTO t3 VALUES('1000-01-01');
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT YEARWEEK(c1) FROM t3;
+YEARWEEK(c1)
+99952
+199952
+199952
+200652
+200808
+DROP TABLE t3;
+CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
+Warnings:
+Warning	1264	Out of range value for column 'c1' at row 1
+INSERT INTO t3 VALUES('1999-12-31');
+INSERT INTO t3 VALUES('2000-01-01');
+INSERT INTO t3 VALUES('2006-12-25');
+INSERT INTO t3 VALUES('2008-02-29');
+SELECT YEARWEEK(c1) FROM t3;
+YEARWEEK(c1)
+NULL
+199952
+199952
+200652
+200808
+DROP TABLE t3;