← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/dayofyear.result

  • Committer: Brian Aker
  • Date: 2009-01-24 09:43:35 UTC
  • Revision ID: brian@gir-3.local-20090124094335-6qdtvc35gl5fvivz
Adding in an example singe thread scheduler

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/dayofyear.result
1
 
SELECT DAYOFYEAR(NULL);
2
 
DAYOFYEAR(NULL)
3
 
NULL
4
 
SELECT DAYOFYEAR();
5
 
ERROR 42000: Incorrect parameter count in the call to native function 'DAYOFYEAR'
6
 
SELECT DAYOFYEAR(1, 0);
7
 
ERROR 42000: Incorrect parameter count in the call to native function 'DAYOFYEAR'
8
 
SELECT DAYOFYEAR("xxx");
9
 
ERROR HY000: Received an invalid datetime value 'xxx'.
10
 
SELECT DAYOFYEAR("0000-00-00");
11
 
ERROR HY000: Received an invalid datetime value '0000-00-00'.
12
 
SELECT DAYOFYEAR("0000-01-01");
13
 
ERROR HY000: Received an invalid datetime value '0000-01-01'.
14
 
SELECT DAYOFYEAR("0001-00-01");
15
 
ERROR HY000: Received an invalid datetime value '0001-00-01'.
16
 
SELECT DAYOFYEAR("0001-01-00");
17
 
ERROR HY000: Received an invalid datetime value '0001-01-00'.
18
 
SELECT DAYOFYEAR("2000-02-30");
19
 
ERROR HY000: Received an invalid datetime value '2000-02-30'.
20
 
SELECT DAYOFYEAR("1900-02-29");
21
 
ERROR HY000: Received an invalid datetime value '1900-02-29'.
22
 
SELECT DAYOFYEAR('1976-15-15');
23
 
ERROR HY000: Received an invalid datetime value '1976-15-15'.
24
 
SELECT DAYOFYEAR("2009-01-01");
25
 
DAYOFYEAR("2009-01-01")
26
 
1
27
 
SELECT DAYOFYEAR("2009-01-12");
28
 
DAYOFYEAR("2009-01-12")
29
 
12
30
 
SELECT DAYOFYEAR("70-12-31");
31
 
DAYOFYEAR("70-12-31")
32
 
365
33
 
SELECT DAYOFYEAR("00-12-31");
34
 
DAYOFYEAR("00-12-31")
35
 
366
36
 
SELECT DAYOFYEAR("0001-01-31");
37
 
DAYOFYEAR("0001-01-31")
38
 
31
39
 
SELECT DAYOFYEAR('07/31/2009');
40
 
DAYOFYEAR('07/31/2009')
41
 
212
42
 
SELECT DAYOFYEAR('20090916');
43
 
DAYOFYEAR('20090916')
44
 
259
45
 
SELECT DAYOFYEAR('20090916091528');
46
 
DAYOFYEAR('20090916091528')
47
 
259
48
 
SELECT DAYOFYEAR("20090916091528.000000");
49
 
DAYOFYEAR("20090916091528.000000")
50
 
259
51
 
SELECT DAYOFYEAR('09-09-16');
52
 
DAYOFYEAR('09-09-16')
53
 
259
54
 
SELECT DAYOFYEAR('09.09.16');
55
 
DAYOFYEAR('09.09.16')
56
 
259
57
 
SELECT DAYOFYEAR('09/09/16');
58
 
DAYOFYEAR('09/09/16')
59
 
259
60
 
SELECT DAYOFYEAR('09-09-16');
61
 
DAYOFYEAR('09-09-16')
62
 
259
63
 
SELECT DAYOFYEAR('09-9-2');
64
 
DAYOFYEAR('09-9-2')
65
 
245
66
 
SELECT DAYOFYEAR(20090916);
67
 
DAYOFYEAR(20090916)
68
 
259
69
 
SELECT DAYOFYEAR(20090916091528);
70
 
DAYOFYEAR(20090916091528)
71
 
259
72
 
SELECT DAYOFYEAR(20090916091528.000001);
73
 
DAYOFYEAR(20090916091528.000001)
74
 
259
75
 
USE test;
76
 
DROP TABLE IF EXISTS t1;
77
 
CREATE TABLE t1 (
78
 
int_fld INT NOT NULL
79
 
, date_fld DATE NOT NULL
80
 
, datetime_fld DATETIME NOT NULL
81
 
, timestamp_fld TIMESTAMP NOT NULL
82
 
, char_fld CHAR(22) NOT NULL
83
 
, varchar_fld VARCHAR(22) NOT NULL
84
 
, text_fld TEXT NOT NULL
85
 
, blob_fld BLOB NOT NULL
86
 
);
87
 
INSERT INTO t1 VALUES (
88
 
20071130
89
 
, "2007-11-30"
90
 
, "2007-11-30 16:30:19"
91
 
, "2007-11-30T16:30:19"
92
 
, "2007-11-30 16:30:19"
93
 
, "2007-11-30 16:30:19"
94
 
, "2007-11-30T16:30:19"
95
 
, "2007-11-30T16:30:19"
96
 
);
97
 
SELECT DAYOFYEAR(int_fld) FROM t1;
98
 
DAYOFYEAR(int_fld)
99
 
334
100
 
SELECT DAYOFYEAR(date_fld) FROM t1;
101
 
DAYOFYEAR(date_fld)
102
 
334
103
 
SELECT DAYOFYEAR(datetime_fld) FROM t1;
104
 
DAYOFYEAR(datetime_fld)
105
 
334
106
 
SELECT DAYOFYEAR(timestamp_fld) FROM t1;
107
 
DAYOFYEAR(timestamp_fld)
108
 
334
109
 
SELECT DAYOFYEAR(char_fld) FROM t1;
110
 
DAYOFYEAR(char_fld)
111
 
334
112
 
SELECT DAYOFYEAR(varchar_fld) FROM t1;
113
 
DAYOFYEAR(varchar_fld)
114
 
334
115
 
SELECT DAYOFYEAR(text_fld) FROM t1;
116
 
DAYOFYEAR(text_fld)
117
 
334
118
 
SELECT DAYOFYEAR(blob_fld) FROM t1;
119
 
DAYOFYEAR(blob_fld)
120
 
334
121
 
DROP TABLE t1;