← 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: 2009-02-18 19:27:32 UTC
  • mfrom: (873.1.17 temporal-new)
  • Revision ID: brian@tangent.org-20090218192732-ype4iscybtftjk2y
Merge Jay

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_time.test
197
197
select quarter("0000-00-00"),quarter(d),quarter(dt),quarter(t),quarter(c) from t1;
198
198
--error 1686 # Argh.  0000-00-00 is not a date.
199
199
select year("0000-00-00"),year(d),year(dt),year(t),year(c) from t1;
 
200
--error 1686 # Bad datetime
200
201
select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(c) from t1;
201
202
--error 1686 # Ugh. bad datetime
202
203
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;
369
370
drop table t1;
370
371
 
371
372
# test for last_day
372
 
select last_day('2000-02-05') as f1, last_day('2002-12-31') as f2,
373
 
       last_day('2003-03-32') as f3, last_day('2003-04-01') as f4,
374
 
       last_day('2001-01-01 01:01:01') as f5, last_day(NULL),
375
 
       last_day('2001-02-12');
 
373
select last_day('2000-02-05');
 
374
select last_day('2002-12-31');
 
375
--error 1686 # Bad date
 
376
select last_day('2003-03-32');
 
377
select last_day('2003-04-01');
 
378
select last_day('2001-01-01 01:01:01');
 
379
select last_day(NULL);
 
380
select last_day('2001-02-12');
376
381
 
377
382
create table t1 select last_day('2000-02-05') as a,
378
383
                from_days(to_days("960101")) as b;
411
416
# Bug #10568
412
417
#
413
418
 
 
419
--error 1686 # Bad date
414
420
select last_day('2005-00-00');
 
421
--error 1686 # Bad date
415
422
select last_day('2005-00-01');
 
423
--error 1686 # Bad date
416
424
select last_day('2005-01-00');
417
425
 
418
426
#
537
545
# Bug #23653: crash if last_day('0000-00-00')
538
546
#
539
547
 
 
548
--error 1686 # Bad date
540
549
select last_day('0000-00-00');
541
550
 
542
551
--echo End of 4.1 tests