← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_time.test

  • Committer: Brian Aker
  • Date: 2011-01-21 20:42:14 UTC
  • mto: This revision was merged to the branch mainline in revision 2103.
  • Revision ID: brian@tangent.org-20110121204214-gqzojh2q9mko1nqx
Isolate out the time code/conversion.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_time.test
173
173
 
174
174
create table t1 (d date, dt datetime, t timestamp, c char(10));
175
175
insert into t1 values (null, null, null, null);
176
 
 
177
 
--error ER_INVALID_DATE_VALUE # Bad dates...
 
176
--error ER_INVALID_DATETIME_VALUE # Bad dates...
178
177
insert into t1 values ("0000-00-00", "0000-00-00", "0000-00-00", "0000-00-00");
179
 
 
180
178
--error ER_INVALID_DATETIME_VALUE # 0000-00-00 is a bad date
181
179
select dayofyear("0000-00-00"),dayofyear(d),dayofyear(dt),dayofyear(t),dayofyear(c) from t1;
182
 
 
183
180
--error ER_INVALID_DATETIME_VALUE # 0000-00-00 is a bad date
184
181
select dayofmonth("0000-00-00"),dayofmonth(d),dayofmonth(dt),dayofmonth(t),dayofmonth(c) from t1;
185
 
 
186
182
--error ER_INVALID_DATETIME_VALUE # 0000-00-00 is not a damn date.
187
183
select month("0000-00-00"),month(d),month(dt),month(t),month(c) from t1;
188
 
 
189
184
--error ER_INVALID_DATETIME_VALUE # 0000-00-00 not a date
190
185
select quarter("0000-00-00"),quarter(d),quarter(dt),quarter(t),quarter(c) from t1;
191
 
 
192
186
--error ER_INVALID_DATETIME_VALUE # Argh.  0000-00-00 is not a date.
193
187
select year("0000-00-00"),year(d),year(dt),year(t),year(c) from t1;
194
 
 
195
188
--error ER_INVALID_DATETIME_VALUE # Bad datetime
196
189
select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(c) from t1;
197
 
 
198
190
--error ER_INVALID_DATETIME_VALUE # Ugh. bad datetime
199
191
select extract(MONTH FROM "0000-00-00"),extract(MONTH FROM d),extract(MONTH FROM dt),extract(MONTH FROM t),extract(MONTH FROM c) from t1;
200
192
drop table t1;