~maria-captains/maria/mysql-6.0-backup

« back to all changes in this revision

Viewing changes to mysql-test/suite/optimizer_unfixed_bugs/r/bug36981.result

  • Committer: Thava Alagu
  • Date: 2010-03-11 19:18:17 UTC
  • mfrom: (3719.14.62 mysql-6.0-codebase)
  • Revision ID: thavamuni.alagu@sun.com-20100311191817-5nigmq884xo9fuut
Merge from mysql-6.0-codebase

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
create table `t1` (`c1` char(1) default null,`c2` char(10) default null,
2
 
key (`c1`))
3
 
engine=innodb default charset=latin1;
4
 
insert into `t1` values ('3',null);
5
 
select * from `t1` where `c1`='3' for update;
6
 
c1      c2
7
 
3       NULL
8
 
drop table `t1`;