← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/type_timestamp.result

  • Committer: Brian Aker
  • Date: 2011-01-13 00:08:59 UTC
  • mto: (2082.4.1 timestamp)
  • mto: This revision was merged to the branch mainline in revision 2098.
  • Revision ID: brian@tangent.org-20110113000859-8dw4ybnp8id56u50
Fix issue with return value from unix_timestamp(). Also clean up error
messages, and remove limit on value for timestamp.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/type_timestamp.result
112
112
drop table t1;
113
113
create table t1 (ix timestamp);
114
114
insert into t1 values (0),(20030101010160),(20030101016001),(20030101240101),(20030132010101),(20031301010101),(20031200000000),(20030000000000);
115
 
ERROR HY000: Received an invalid value '0' for a UNIX timestamp.
 
115
ERROR HY000: Received an invalid timestamp value '0'.
116
116
select ix+0 from t1;
117
117
ix+0
118
118
truncate table t1;
119
119
insert into t1 values ("00000000000000"),("20030101010160"),("20030101016001"),("20030101240101"),("20030132010101"),("20031301010101"),("20031200000000"),("20030000000000");
120
 
ERROR HY000: Received an invalid value '00000000000000' for a UNIX timestamp.
 
120
ERROR HY000: Received an invalid timestamp value '00000000000000'.
121
121
select ix+0 from t1;
122
122
ix+0
123
123
truncate table t1;
124
124
insert into t1 values ("0000-00-00 00:00:00 some trailer"),("2003-01-01 00:00:00 some trailer");
125
 
ERROR HY000: Received an invalid value '0000-00-00 00:00:00 some trailer' for a UNIX timestamp.
 
125
ERROR HY000: Received an invalid timestamp value '0000-00-00 00:00:00 some trailer'.
126
126
select ix+0 from t1;
127
127
ix+0
128
128
drop table t1;