← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Brian Aker
  • Date: 2008-08-20 04:57:36 UTC
  • Revision ID: brian@tangent.org-20080820045736-osva4aqejairc12k
More modes removed. 0 always becomes new number again

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/select.result
2834
2834
f1      f2
2835
2835
4       2005-10-01
2836
2836
5       2005-12-30
 
2837
Warnings:
 
2838
Warning 1292    Incorrect date value: '2005-09-31' for column 'f2' at row 1
2837
2839
select * from t1 where f2 >= '2005-09-3a' order by f2;
2838
2840
f1      f2
2839
2841
3       2005-09-30
2846
2848
1       2005-01-01
2847
2849
2       2005-09-01
2848
2850
3       2005-09-30
 
2851
Warnings:
 
2852
Warning 1292    Incorrect date value: '2005-09-31' for column 'f2' at row 1
2849
2853
select * from t1 where f2 <= '2005-09-3a' order by f2;
2850
2854
f1      f2
2851
2855
1       2005-01-01
3701
3705
Warning 1292    Truncated incorrect datetime value: '2007-10-01 12:34'
3702
3706
select str_to_date('2007-02-30 12:34','%Y-%m-%d %H:%i') = '2007-02-30 12:34';
3703
3707
str_to_date('2007-02-30 12:34','%Y-%m-%d %H:%i') = '2007-02-30 12:34'
3704
 
1
 
3708
0
 
3709
Warnings:
 
3710
Warning 1292    Truncated incorrect datetime value: '2007-02-30 12:34'
3705
3711
select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';
3706
3712
str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'
3707
3713
1