test/sqlapi/Select/test005.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # check options -D chunk with empty database
   4 #create table t1 (f1,f2) check with -D chunk
   5 #drop t1  check with -D chunk
   6
   7 CSQL_CONF=${PWD}/sqlapi/Select/csql.conf
   8 REL_PATH=.
   9 if [ -s "$CSQL_CONF" ]
  10 then
  11     REL_PATH=${PWD}/sqlapi/Select
  12 fi
  13 export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  14
  15 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  16 pid=$!
  17 sleep 5
  18 echo "Case 1: create table t1 ,test for SET AUTOCOMMIT OFF and some records "
  19 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/create.sql 2>&1
  20 if [ $? -ne 0 ]
  21 then
  22    exit 1;
  23 fi
  24
  25 kill -9 $pid
  26 ipcrm -M 1199 -M 2277
  27 exit 0;
  28