test/tools/csql/test036.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # 36. Create table t1 with composite primary key.
   4 #     t1(f1 int, f2 int, primary key(f1, f2));
   5 #     create one more index indx on t1(f1).
   6 #     the index should be created.
   7
   8 QUITFILE=${PWD}/tools/csql/quit.sql
   9 REL_PATH=.
  10 if [ -s "$QUITFILE" ]
  11 then
  12     REL_PATH=`pwd`/tools/csql
  13 fi
  14
  15 if [ "$VALGRIND" = "true" ]
  16 then
  17     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/singleandcompind.sql 2> $0.valgr
  18 else
  19     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/singleandcompind.sql 2 >&1
  20     if [ $? -ne 0 ]
  21     then
  22        exit 1;
  23     fi
  24 fi
  25
  26 if [ "$VALGRIND" = "true" ]
  27 then
  28     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l 2>> $0.valgr
  29 else
  30     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  31     if [ $? -ne 0 ]
  32     then
  33        exit 2;
  34     fi
  35 fi
  36
  37 if [ "$VALGRIND" = "true" ]
  38 then
  39     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop1.sql 2>> $0.valgr
  40 else
  41     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop1.sql
  42     if [ $? -ne 0 ]
  43     then
  44        exit 3;
  45     fi
  46 fi
  47
  48 exit 0;