test007.ksh

b树实现源码,linux和unix下运行,速度快,极好用

#!/bin/sh
# TestCase:
# check pages used(normal and merged) and chunks used for user database
# for i = 1 to 100
#    create table t1 with two fields and index on first field
#    create index idx1 on t1 (f1)
#    drop table t1
# end for
# check pages used(normal and merged) and chunks used for user database

#Run this test only under csql/test or on this directory.
#Otherwise, it may fail
EXECUTABLE=${PWD}/system/Allocator/create
REL_PATH=.
if [ -s "$EXECUTABLE" ]
then
    REL_PATH=${PWD}/system/Allocator
fi

echo "Case 1: -d option with no table"
$CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 
if [ $? -ne 0 ]
then
   exit 1;
fi

echo "Tables and Indexes are created"

echo "Case 2: -d option with 1 table"
count=100
while [ ${count} -gt 0 ]
do 
  count=`expr ${count} - 1`
  ${REL_PATH}/create
  if [ $? -ne 0 ]
  then
    echo "create table failed"
    exit 100;
  fi
  ${REL_PATH}/drop
  if [ $? -ne 0 ]
  then
    echo "drop table failed"
    exit 100;
  fi
done
$CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 
if [ $? -ne 0 ]
then
   exit 1;
fi
exit 0