create database if not exists a; use a; drop table if exists t1; drop table if exists t2; create table `t1` (`a` double(3,2) default null,`b` varbinary(1) default null) engine=myisam; create table `t2` ( `a` smallint(2) default null,`b` binary(8) not null) engine=myisam; insert into `t1` values (9.99,'f'); insert into `t1` values (9.99,'a'); insert into `t1` values (9.99,'1'); insert into `t1` values (9.99,'l'); insert into `t1` values (9.99,','); insert into `t1` values (9.99,'0'); insert into `t1` values (9.99,'a'); insert into `t1` values (9.99,'3'); insert into `t1` values (9.99,'3'); insert into `t1` values (9.99,'i'); insert into `t1` values (9.99,'r'); insert into `t1` values (9.99,'x'); insert into `t1` values (9.99,'y'); insert into `t1` values (null,'4'); insert into `t1` values (null,';'); insert into `t1` values (9.99,'v'); insert into `t1` values (9.99,'7'); insert into `t1` values (null,'e'); insert into `t1` values (null,'e'); insert into `t1` values (null,'a'); insert into `t1` values (9.99,'u'); insert into `t1` values (9.99,'u'); insert into `t1` values (9.99,'y'); insert into `t1` values (9.99,'p'); insert into `t1` values (9.99,'l'); insert into `t1` values (9.99,' '); insert into `t1` values (9.99,'k'); insert into `t1` values (null,'.'); insert into `t1` values (9.99,'8'); insert into `t1` values (9.99,'e'); insert into `t1` values (9.99,'k'); insert into `t1` values (9.99,'6'); insert into `t1` values (9.99,'5'); insert into `t1` values (9.99,'d'); insert into `t1` values (9.99,' '); insert into `t1` values (null,'9'); insert into `t1` values (9.99,'p'); insert into `t1` values (9.99,'p'); insert into `t1` values (9.99,'0'); insert into `t1` values (9.99,'w'); insert into `t1` values (null,'g'); insert into `t1` values (null,'2'); insert into `t1` values (9.99,'m'); insert into `t1` values (9.99,'n'); insert into `t1` values (9.99,'a'); insert into `t1` values (9.99,'e'); insert into `t1` values (9.99,'x'); insert into `t1` values (9.99,'t'); insert into `t1` values (9.99,':'); insert into `t1` values (9.99,'i'); insert into `t1` values (9.99,'l'); insert into `t1` values (9.99,'n'); insert into `t1` values (9.99,'7'); insert into `t1` values (9.99,'e'); insert into `t1` values (null,'6'); insert into `t1` values (9.99,'c'); insert into `t1` values (9.99,' '); insert into `t1` values (9.99,':'); insert into `t1` values (9.99,'n'); insert into `t1` values (9.99,'m'); insert into `t1` values (null,'c'); insert into `t1` values (null,'w'); insert into `t1` values (9.99,' '); insert into `t1` values (9.99,'q'); insert into `t1` values (9.99,' '); insert into `t1` values (9.99,'e'); insert into `t1` values (9.99,'\n'); insert into `t1` values (9.99,'m'); insert into `t1` values (null,':'); insert into `t1` values (null,'j'); insert into `t1` values (9.99,'j'); insert into `t1` values (9.99,'w'); insert into `t1` values (9.99,'c'); insert into `t1` values (9.99,'o'); insert into `t1` values (9.99,'h'); insert into `t1` values (9.99,''); insert into `t1` values (9.99,'v'); insert into `t1` values (9.99,'j'); insert into `t1` values (9.99,'9'); insert into `t1` values (9.99,'z'); insert into `t1` values (9.99,'9'); insert into `t1` values (9.99,'u'); insert into `t1` values (null,'q'); insert into `t1` values (9.99,'p'); insert into `t1` values (9.99,'t'); insert into `t1` values (9.99,'c'); insert into `t1` values (9.99,'g'); insert into `t1` values (9.99,'s'); insert into `t1` values (null,','); insert into `t1` values (null,'a'); insert into `t1` values (9.99,'h'); insert into `t1` values (9.99,'4'); insert into `t1` values (null,'h'); insert into `t1` values (9.99,'i'); insert into `t1` values (9.99,'h'); insert into `t1` values (9.99,'v'); insert into `t1` values (9.99,'5'); insert into `t1` values (9.99,';'); insert into `t1` values (9.99,'u'); insert into `t2` values (17967,'4lsma:h '); insert into `t2` values (null,' cbkmajz'); insert into `t2` values (null,'k4l,tzzn'); insert into `t2` values (null,'od4kqlfs'); insert into `t2` values (-11670,'ucljmi7n'); insert into `t2` values (11592,'klmwyfa9'); insert into `t2` values (-13734,'9s,cxxs '); insert into `t2` values (32083,'veyce1sl'); insert into `t2` values (-32645,'achfrmrz'); insert into `t2` values (1825,'bv2.s go'); insert into `t2` values (16982,'md uvffb'); insert into `t2` values (null,'a5\ny.zv '); insert into `t2` values (962,'3kpvab,f'); insert into `t2` values (11827,'c d.xjp.'); insert into `t2` values (-27937,'ojxwu0ha'); insert into `t2` values (null,'7alyfcpl'); insert into `t2` values (null,'kvv\nj3t '); insert into `t2` values (-663,'eemwygut'); insert into `t2` values (-842,'e48xydli'); insert into `t2` values (31391,'rtlza l,'); insert into `t2` values (-7203,'f4g.vzze'); insert into `t2` values (22407,'7clpa94w'); insert into `t2` values (-6179,'1vy9gmte'); insert into `t2` values (-6023,'km almpl'); insert into `t2` values (21055,'kafm gr;'); insert into `t2` values (-30339,'l8uov st'); insert into `t2` values (null,'vnanyua '); insert into `t2` values (null,'f23,0x8x'); insert into `t2` values (null,':uc4p.wa'); insert into `t2` values (-18686,'\0\0\0\0\0\0\0\0'); insert into `t2` values (-31583,'lmsgntbr'); insert into `t2` values (22141,'sc6daqg4'); insert into `t2` values (null,'pvgwthp '); insert into `t2` values (-25528,'e,a9gvui'); insert into `t2` values (-10018,'zn kulmp'); insert into `t2` values (25897,'kgusu\0\0\0'); insert into `t2` values (-13165,'l flxfiw'); insert into `t2` values (18787,'m39\ns1be'); insert into `t2` values (30057,'eq;enmeo'); insert into `t2` values (null,'j.erz,a '); insert into `t2` values (7435,'jrg7smze'); insert into `t2` values (21010,'smrzdsn\n'); insert into `t2` values (31299,'xu.o7mfj'); insert into `t2` values (-29788,'vukw,.tc'); insert into `t2` values (-798,'etxnortc'); insert into `t2` values (21598,'.9gudald'); insert into `t2` values (-27777,'gpy.am: '); insert into `t2` values (null,'\n v5eke4'); insert into `t2` values (null,'qz,rd.hq'); insert into `t2` values (-27544,';:\0\0\0\0\0\0'); insert into `t2` values (2427,';tdhxev:'); insert into `t2` values (15855,'pru2cea.'); insert into t1 values (),(),(); insert into t2 values (),(),(); select t2.b from t1,t2 where t1.a not in (select t2.b from t1,t2) and not t1.a not in (select b from t2);