101 lines
1.9 KiB
PHP
101 lines
1.9 KiB
PHP
|
|
eval create table t1(
|
|
a $type1,
|
|
b $type2,
|
|
c int,
|
|
primary key(a),
|
|
unique(b)
|
|
) charset latin1 engine ndb;
|
|
--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)
|
|
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;
|
|
while ($i)
|
|
{
|
|
--eval select * from t1 where a="$i"
|
|
dec $i;
|
|
}
|
|
|
|
--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"
|
|
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;
|
|
while ($i)
|
|
{
|
|
--eval update t1 set c="10" where a="$i"
|
|
dec $i;
|
|
}
|
|
--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 c="11" where b="$i"
|
|
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;
|
|
while ($i)
|
|
{
|
|
--eval delete from t1 where a="$i"
|
|
dec $i;
|
|
}
|
|
--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"
|
|
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;
|