← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/t/type_date.test

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/type_date.test
123
123
select 1 from t1 where cast('2000-01-01 12:01:01' as datetime) between start_date and end_date;
124
124
drop table t1;
125
125
# End of 4.1 tests
 
126
 
 
127
#
 
128
# Bug #23093: Implicit conversion of 9912101 to date does not match
 
129
# cast(9912101 as date)
 
130
#
 
131
select @d:=1111, year(@d), month(@d), day(@d), cast(@d as date);
 
132
select @d:=011111, year(@d), month(@d), day(@d), cast(@d as date);
 
133
select @d:=1311, year(@d), month(@d), day(@d), cast(@d as date);
 
134
create table t1 (d  date , dt datetime , ts timestamp);
 
135
insert into t1 values (9912101,9912101,9912101);
 
136
insert into t1 values (11111,11111,11111);
 
137
select * from t1;
 
138
drop table t1;