#-- source include/have_ndb.inc--disable_warningsdroptableifexistst1;droptableifexistst2;--enable_warnings########### bug#5367createtablet1(pintnotnullprimarykey,uintnotnull,ointnotnull,unique(u),key(o))engine=ndb;createtablet2(pintnotnullprimarykey,uintnotnull,ointnotnull,unique(u),key(o))engine=ndb;insertintot1values(1,1,1),(2,2,2),(3,3,3);insertintot2values(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5);# Use pkexplainselect*fromt2wherepNOTIN(selectpfromt1);select*fromt2wherepNOTIN(selectpfromt1);# Use unique indexexplainselect*fromt2wherepNOTIN(selectufromt1);select*fromt2wherepNOTIN(selectufromt1);# Use ordered indexexplainselect*fromt2wherepNOTIN(selectofromt1);select*fromt2wherepNOTIN(selectofromt1);# Use scanexplainselect*fromt2wherepNOTIN(selectp+0fromt1);select*fromt2wherepNOTIN(selectp+0fromt1);droptablet1;droptablet2;# bug#5367##########