← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/myisam/tests/r/mix2_myisam.result

  • Committer: Brian Aker
  • Date: 2011-01-19 18:03:32 UTC
  • mfrom: (2088.8.12 timestamp)
  • mto: This revision was merged to the branch mainline in revision 2098.
  • Revision ID: brian@tangent.org-20110119180332-acfk5i8oofp63s40
Merge in time code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/myisam/tests/r/mix2_myisam.result
873
873
create TEMPORARY table t2 (col1 int,stamp TIMESTAMP,INDEX stamp_idx
874
874
(stamp))ENGINE=MyISAM;
875
875
insert into t1 values (1),(2),(3);
876
 
insert into t2 values (1, 20020204130000),(2, 20020204130000),(4,20020204310000 ),(5,20020204230000);
877
 
ERROR HY000: Received an invalid value '20020204310000' for a UNIX timestamp.
878
 
SELECT col1 FROM t1 UNION SELECT col1 FROM t2 WHERE stamp <
879
 
'20020204120000' GROUP BY col1;
 
876
insert into t2 values (1, 20020204130000);
 
877
insert into t2 values (2, 20020204130000);
 
878
insert into t2 values (4, 20020204310000);
 
879
ERROR HY000: Received an invalid timestamp value '20020204310000'.
 
880
insert into t2 values (5, 20020204230000);
 
881
SELECT col1 FROM t1 UNION SELECT col1 FROM t2 WHERE stamp < '20020204120000' GROUP BY col1;
880
882
col1
881
883
1
882
884
2