2
# Tests for the HOUR() function
4
# The Drizzle HOUR() function differs from the MySQL HOUR()
5
# function in these ways:
7
# * Does not accept invalid parameters. This results in an error
11
# HOUR() on a NULL should produce
16
# Test improper argument list
20
# Wrong parameter count...but unfortunately produces 1064 Syntax Error due to limitations of
21
# the SQL parser, which considers HOUR a keyword before being a function symbol
24
# Wrong parameter count...but unfortunately produces 1064 Syntax Error due to limitations of
25
# the SQL parser, which considers HOUR a keyword before being a function symbol
29
# Test invalid dates passed to HOUR
30
# produce an error, not a NULL or anything
39
# The following are all bad dates, with no possibility of interpreting
40
# the values as TIME-only components.
43
SELECT HOUR("0000-00-00"); # No 0000-00-00 dates!...
45
SELECT HOUR("0000-01-01"); # No zero year parts
47
SELECT HOUR("0001-00-01"); # No zero month parts
49
SELECT HOUR("0001-01-00"); # No zero day parts
51
SELECT HOUR("2000-02-30"); # No Feb 30th!
53
SELECT HOUR("1900-02-29"); # Not a leap HOUR since not divisible evenly by 400...
55
SELECT HOUR('1976-15-15'); # No 15th month!
57
SELECT HOUR('23:59:70'); # No 70th second!
59
SELECT HOUR('23:70:59'); # No 70th minute!
61
SELECT HOUR('26:00:00'); # No 26th hour!
63
# A good date, which cannot be interpreted as a TIME component. Should return 0.
64
SELECT HOUR("2009-01-12");
66
# A good date, which should output 0 since no TIME component - Test of 2 digit year conversion...
67
SELECT HOUR("70-12-31");
69
# A good date in the common USA format, should output 0 since no TIME component
70
SELECT HOUR('07/31/2009');
72
# A good datetime, should output 3
73
SELECT HOUR("2008-11-30 03:30:15");
75
# A good datetime, should output 3
76
SELECT HOUR("2008-11-30T03:30:15");
78
# A good datetime, should output 3
79
SELECT HOUR("20081130033015");
81
# A good datetime, interpreted int->string, should output 3
82
SELECT HOUR(20081130033015);
84
# A good datetime with subsecond component, interpreted int->string, should output 3
85
SELECT HOUR(20081130033015.01);
87
# A good time (according to MySQL, not Jay Pipes...), should output 23
90
# A good time (according to MySQL, not Jay Pipes...), should output 23
91
SELECT HOUR("231115");
93
# A good time, should output 23
94
SELECT HOUR("23:59:59");
96
# Now test field values of different types
100
DROP TABLE IF EXISTS t1;
104
, date_fld DATE NOT NULL
105
, datetime_fld DATETIME NOT NULL
106
, timestamp_fld TIMESTAMP NOT NULL
107
, char_fld CHAR(22) NOT NULL
108
, varchar_fld VARCHAR(22) NOT NULL
109
, text_fld TEXT NOT NULL
110
, blob_fld BLOB NOT NULL
113
# Should all output 16 except first 2, which should output 0.
114
INSERT INTO t1 VALUES (
117
, "2007-11-30 16:30:19"
118
, "2007-11-30T16:30:19"
119
, "2007-11-30 16:30:19"
120
, "2007-11-30 16:30:19"
121
, "2007-11-30T16:30:19"
122
, "2007-11-30T16:30:19"
125
SELECT HOUR(int_fld) FROM t1;
126
SELECT HOUR(date_fld) FROM t1;
127
SELECT HOUR(datetime_fld) FROM t1;
128
SELECT HOUR(timestamp_fld) FROM t1;
129
SELECT HOUR(char_fld) FROM t1;
130
SELECT HOUR(varchar_fld) FROM t1;
131
SELECT HOUR(text_fld) FROM t1;
132
SELECT HOUR(blob_fld) FROM t1;
added
removed
tests/t/hour.test
