~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/type_date.result

  • Committer: Brian Aker
  • Date: 2011-01-26 21:05:29 UTC
  • mto: (2122.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2123.
  • Revision ID: brian@tangent.org-20110126210529-2y7gt9xg9fz1b29c
Fix error message on date.

Show diffs side-by-side

added added

removed removed

Lines of Context:
112
112
@d:=1311
113
113
1311
114
114
select year(@d), month(@d), day(@d), cast(@d as date);
115
 
ERROR HY000: Received an invalid datetime value '1311'.
 
115
Got one of the listed errors
116
116
create table t1 (d  date , dt datetime , ts timestamp);
117
117
insert into t1 values (9912101,9912101,9912101);
118
 
ERROR HY000: Received an invalid datetime value '9912101'.
 
118
ERROR HY000: Received an invalid DATE value '9912101'.
119
119
insert into t1 values (11111,11111,11111);
120
120
select * from t1;
121
121
d       dt      ts