~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/type_datetime.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:
187
187
insert into t1 values ('2007-03-23 13:49:38','2007-03-23 13:49:38');
188
188
insert into t1 set dt='2007-03-23 13:49:38',da=dt;
189
189
insert into t1 values ('2007-03-32','2007-03-23 13:49:38');
190
 
ERROR HY000: Received an invalid datetime value '2007-03-32'.
 
190
ERROR HY000: Received an invalid DATE value '2007-03-32'.
191
191
select * from t1;
192
192
da      dt
193
193
1962-03-03      1962-03-03 00:00:00
457
457
insert into t1 values ('2007-03-23 13:49:38','2007-03-23 13:49:38');
458
458
insert into t1 set dt='2007-03-23 13:49:38',da=dt;
459
459
insert into t1 values ('2007-03-32','2007-03-23 13:49:38');
460
 
ERROR HY000: Received an invalid datetime value '2007-03-32'.
 
460
ERROR HY000: Received an invalid DATE value '2007-03-32'.
461
461
select * from t1;
462
462
da      dt
463
463
1962-03-03      1962-03-03 00:00:00