test/sql/Datatype/test006.ksh

   1 #!/bin/ksh
   2 # Tree Index, Unique Tree Index
   3 # create table t1 (f1 varchar(10), f2 smallint);
   4 # create table t2 (f1 varchar(10), f2 smallint);
   5 # create index idx1 on t1(f1)tree;
   6 # create index idx2 on t2(f1)tree unique;
   7 # Error out saying varchar not supported for tree index
   8 #
   9 CREATEFILE=${PWD}/sql/Datatype/csql.conf
  10 REL_PATH=.
  11 if [ -s "$CREATEFILE" ]
  12 then
  13     REL_PATH=`pwd`/sql/Datatype
  14 fi
  15
  16 echo "drop table t1;" >${REL_PATH}/drop.sql
  17 echo "drop table t2;" >>${REL_PATH}/drop.sql
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql >/dev/null 2>&1
  20
  21 if [ "$VALGRIND" = "true" ]
  22 then
  23     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar_tree.sql
  24 else
  25     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar_tree.sql
  26     if [ $? -ne 0 ]
  27     then
  28        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql
  29        rm -f ${REL_PATH}/drop.sql
  30        exit 1;
  31     fi
  32 fi
  33
  34 if [ "$VALGRIND" = "true" ]
  35 then
  36     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  37 else
  38     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  39 fi
  40
  41 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql
  42 if [ $? -ne 0 ]
  43 then
  44    exit 2;
  45 fi
  46
  47 rm -f ${REL_PATH}/drop.sql
  48 exit 0;