← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix2.inc

  • Committer: Brian Aker
  • Date: 2011-01-20 15:27:43 UTC
  • mfrom: (2097.1.7 drizzle-build)
  • Revision ID: brian@tangent.org-20110120152743-x88aq1sj1k9andwm
Merge of all of the time fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/mix2.inc
929
929
eval create $temp table t2 (col1 int,stamp TIMESTAMP,INDEX stamp_idx
930
930
(stamp))ENGINE=$engine_type;
931
931
insert into t1 values (1),(2),(3);
932
 
# Note that timestamp 3 is wrong
933
 
--error 1685 # Bad timestamp
934
 
insert into t2 values (1, 20020204130000),(2, 20020204130000),(4,20020204310000 ),(5,20020204230000);
935
 
SELECT col1 FROM t1 UNION SELECT col1 FROM t2 WHERE stamp <
936
 
'20020204120000' GROUP BY col1;
 
932
insert into t2 values (1, 20020204130000);
 
933
insert into t2 values (2, 20020204130000);
 
934
--error ER_INVALID_TIMESTAMP_VALUE # Bad timestamp
 
935
insert into t2 values (4, 20020204310000);
 
936
insert into t2 values (5, 20020204230000);
 
937
SELECT col1 FROM t1 UNION SELECT col1 FROM t2 WHERE stamp < '20020204120000' GROUP BY col1;
937
938
drop table t1,t2;
938
939
 
939
940
#