test/system/Allocator/test006.ksh

   1 #!/bin/ksh
   2 # TestCase:
   3 # check pages used(normal and merged) and chunks used for user database
   4 # create table t1 with two fields and index on first field
   5 # create index idx1 on t1 (f1)
   6 # check pages used(normal and merged) and chunks used for user database
   7 # drop table t1
   8 # check pages used(normal and merged) and chunks used for user database
   9
  10 #Run this test only under csql/test or on this directory.
  11 #Otherwise, it may fail
  12 EXECUTABLE=${PWD}/system/Allocator/create
  13 REL_PATH=.
  14 if [ -s "$EXECUTABLE" ]
  15 then
  16     REL_PATH=${PWD}/system/Allocator
  17 fi
  18
  19 echo "Case 1: -d option with no table"
  20 if [ $VALGRIND = "true" ]
  21 then
  22     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 2> $0.valgr
  23 else
  24     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  25     if [ $? -ne 0 ]
  26     then
  27        exit 1;
  28     fi
  29 fi
  30 if [ $VALGRIND = "true" ]
  31 then
  32     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/create 2>> $0.valgr
  33 else
  34     ${REL_PATH}/create
  35     if [ $? -ne 0 ]
  36     then
  37        exit 100;
  38     fi
  39 fi
  40
  41 echo "Tables and Indexes are created"
  42
  43 echo "Case 2: -d option with 1 table"
  44 if [ $VALGRIND = "true" ]
  45 then
  46     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 2>> $0.valgr
  47 else
  48     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  49     if [ $? -ne 0 ]
  50     then
  51        exit 1;
  52     fi
  53 fi
  54 if [ $VALGRIND = "true" ]
  55 then
  56     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/drop 2>> $0.valgr
  57 else
  58     ${REL_PATH}/drop
  59     if [ $? -ne 0 ]
  60     then
  61        exit 100;
  62     fi
  63 fi
  64 echo "Case 3: -d option after removing table"
  65 if [ $VALGRIND = "true" ]
  66 then
  67     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 2>> $0.valgr
  68 else
  69     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  70     if [ $? -ne 0 ]
  71     then
  72        exit 3;
  73     fi
  74 fi
  75 exit 0