← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/microtime_type/t/basic.test

  • 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/suite/microtime_type/t/basic.test
83
83
# (for both strings and numbers)
84
84
#
85
85
create table t1 (ix TIMESTAMP(6));
86
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad unix TIMESTAMP(6)
 
86
--error ER_INVALID_TIMESTAMP_VALUE # Bad unix TIMESTAMP(6)
87
87
insert into t1 values (0),(20030101010160),(20030101016001),(20030101240101),(20030132010101),(20031301010101),(20031200000000),(20030000000000);
88
88
select ix+0 from t1;
89
89
truncate table t1;
90
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad unix TIMESTAMP(6)
 
90
--error ER_INVALID_TIMESTAMP_VALUE # Bad unix TIMESTAMP(6)
91
91
insert into t1 values ("00000000000000"),("20030101010160"),("20030101016001"),("20030101240101"),("20030132010101"),("20031301010101"),("20031200000000"),("20030000000000");
92
92
select ix+0 from t1;
93
93
truncate table t1;
94
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad unix TIMESTAMP(6)
 
94
--error ER_INVALID_TIMESTAMP_VALUE # Bad unix TIMESTAMP(6)
95
95
insert into t1 values ("0000-00-00 00:00:00 some trailer"),("2003-01-01 00:00:00 some trailer");
96
96
select ix+0 from t1;
97
97
drop table t1;