test/sql/DDL/test005.ksh

   1 #!/bin/ksh
   2 # create trie index with existing records
   3 #
   4 QUITFILE=${PWD}/sql/DDL/drop.sql
   5 REL_PATH=.
   6 if [ -s "$QUITFILE" ]
   7 then
   8 REL_PATH=`pwd`/sql/DDL
   9 fi
  10
  11 echo "drop table t1;">>${REL_PATH}/dropt1.sql
  12
  13 echo "create table t1 ( f1 int not null);" >${REL_PATH}/createt1.sql
  14 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createt1.sql >/dev/null 2>&1
  15 echo "insert into t1 values (10);" >${REL_PATH}/insertt1.sql
  16 echo "insert into t1 values (100);" >>${REL_PATH}/insertt1.sql
  17 echo "insert into t1 values (1000);" >>${REL_PATH}/insertt1.sql
  18 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/insertt1.sql >/dev/null 2>&1
  19
  20 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/create_trie.sql
  21 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I idx
  22 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1.sql
  23 rm -f ${REL_PATH}/dropt1.sql
  24 rm -f ${REL_PATH}/createt1.sql
  25 exit 0;
  26