← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/type_datetime.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/type_datetime.result
26
26
test.t1 check   status  OK
27
27
delete from t1;
28
28
insert into t1 values("000101"),("691231"),("700101"),("991231"),("00000101"),("00010101"),("99991231"),("00101000000"),("691231000000"),("700101000000"),("991231235959"),("10000101000000"),("99991231235959"),("20030100000000"),("20030000000000");
29
 
Warnings:
30
 
Warning 1264    Out of range value for column 't' at row 5
31
29
insert into t1 values ("2003-003-03");
32
30
insert into t1 values ("20030102T131415"),("2001-01-01T01:01:01"), ("2001-1-1T1:01:01");
33
31
select * from t1;
36
34
2069-12-31 00:00:00
37
35
1970-01-01 00:00:00
38
36
1999-12-31 00:00:00
39
 
0000-00-00 00:00:00
 
37
0000-01-01 00:00:00
40
38
0001-01-01 00:00:00
41
39
9999-12-31 00:00:00
42
40
2000-10-10 00:00:00