ndb_dbug_tc_select_3.inc

--eval create table t1 (a $type1, b $type2, c $type3, d int, e $type4, primary key(a,c,e), unique(c,b,d)) engine ndb partition by key(c,e)
--exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all error 8072" >> $NDB_TOOLS_OUTPUT

--echo # verify tc select on insert using simple int key
--disable_query_log
--disable_result_log
let $i= 100;
let $j= 1;
while ($i)
{
--eval insert into t1 values ("$i","$j",0,0,"$j")
dec $i;
inc $j;
}
--enable_query_log
--enable_result_log

--echo # verify tc select on select using simple pk int key
--disable_query_log
--disable_result_log
let $i= 100;
let $j= 1;
while ($i)
{
--eval select * from t1 where a="$i" and c="0" and e="$j"
dec $i;
inc $j;
}

--enable_query_log
--enable_result_log

--echo # verify tc select on select using simple unique int key
--disable_query_log
--disable_result_log
let $i= 100;
while ($i)
{
--eval select * from t1 where b="$i" and c="0" and d="0"
dec $i;
}
--enable_query_log
--enable_result_log

--echo # verify tc select on update using simple pk int key
--disable_query_log
--disable_result_log
let $i= 100;
let $j= 1;
while ($i)
{
--eval update t1 set d="10" where a="$i" and c="0" and e="$j"
dec $i;
inc $j;
}
--enable_query_log
--enable_result_log

--echo # verify tc select on update using simple unique int key
--disable_query_log
--disable_result_log
let $i= 100;
while ($i)
{
--eval update t1 set d=11 where b="$i" and c="0" and d="0"
dec $i;
}
--enable_query_log
--enable_result_log

--echo # verify tc select on delete using simple pk int key
--disable_query_log
--disable_result_log
let $i= 40;
let $j= 1;
while ($i)
{
--eval delete from t1 where a="$i" and c="0" and e="$j"
dec $i;
inc $j;
}
--enable_query_log
--enable_result_log

--echo # verify tc select on delete using simple unique int key
--disable_query_log
--disable_result_log
let $i= 40;
while ($i)
{
--eval delete from t1 where b="$i" and c="0" and d="0"
dec $i;
}
--enable_query_log
--enable_result_log

--echo # Cleanup
--exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all error 0" >> $NDB_TOOLS_OUTPUT
drop table t1;