← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/date_formats.result

  • Committer: Jay Pipes
  • Date: 2009-01-29 22:22:50 UTC
  • mto: This revision was merged to the branch mainline in revision 830.
  • Revision ID: jpipes@serialcoder-20090129222250-buvsi8e6jxy4j8bp
Fixed date_formats.test which was failing due to an invalid datetime that is now being properly caught.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/date_formats.result
496
496
select str_to_date("2003-01-02 10:11:12.0012ABCD", "%Y-%m-%d %H:%i:%S.%f") as f1,
497
497
addtime("-01:01:01.01 GGG", "-23:59:59.1") as f2,
498
498
microsecond("1997-12-31 23:59:59.01XXXX") as f3;
499
 
f1      f2      f3
500
 
2003-01-02 10:11:12.001200      -25:01:00.110000        10000
501
 
Warnings:
502
 
Warning 1292    Truncated incorrect datetime value: '2003-01-02 10:11:12.0012ABCD'
503
 
Warning 1292    Truncated incorrect time value: '-01:01:01.01 GGG'
504
 
Warning 1292    Truncated incorrect time value: '1997-12-31 23:59:59.01XXXX'
 
499
ERROR HY000: Received an invalid datetime value '1997-12-31 23:59:59.01XXXX'.
505
500
select str_to_date("2003-04-05  g", "%Y-%m-%d") as f1,
506
501
str_to_date("2003-04-05 10:11:12.101010234567", "%Y-%m-%d %H:%i:%S.%f") as f2;
507
502
f1      f2