test/system/Allocator/test001.ksh

   1 #!/bin/ksh
   2 # TestCase:
   3 # create table with two fields and index on first field
   4 # insert 1 tuple
   5 # check number of tuples, totalPagesused
   6 # check pagesUsed for storing hash bucket
   7 # check number of index nodes, pagesUsed for storing index nodes
   8 # delete 1 tuple
   9 # check number of tuples, totalPagesused
  10 # check pagesUsed for storing hash bucket
  11 # check number of index nodes, pagesUsed for storing index nodes
  12
  13 # Note: spaceused for table = noOfDataNodes * sizeofTuple + noOfPages * sizeofPageInfo
  14 #Note:Thats why we see spaceused as 16 even when no tuple exist
  15
  16 #Run this test only under csql/test or on this directory.
  17 #Otherwise, it may fail
  18 EXECUTABLE=${PWD}/system/Allocator/create
  19 REL_PATH=.
  20 if [ -s "$EXECUTABLE" ]
  21 then
  22     REL_PATH=${PWD}/system/Allocator
  23 fi
  24
  25 if [ $VALGRIND = "true" ]
  26 then
  27     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/create 2> $0.valgr
  28 else
  29     ${REL_PATH}/create
  30     if [ $? -ne 0 ]
  31     then
  32        exit 100;
  33     fi
  34 fi
  35
  36 echo "Tables and Indexes are created"
  37 if [ $VALGRIND = "true" ]
  38 then
  39     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/insert1 2>> $0.valgr
  40 else
  41     ${REL_PATH}/insert1
  42     if [ $? -ne 1 ]
  43     then
  44        exit 100;
  45     fi
  46 fi
  47 echo "Tuples inserted into table"
  48 echo "Case 1: -T option for t1: with 1 tuple"
  49 if [ $VALGRIND = "true" ]
  50 then
  51     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1 2>> $0.valgr
  52 else
  53     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1
  54     if [ $? -ne 0 ]
  55     then
  56        exit 1;
  57     fi
  58 fi
  59 echo "Case 2: -I option for idx1 of t1, with 1 tuple"
  60 if [ $VALGRIND = "true" ]
  61 then
  62     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I t1idx1 2>> $0.valgr
  63 else
  64     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I t1idx1
  65     if [ $? -ne 0 ]
  66     then
  67        exit 2;
  68     fi
  69 fi
  70
  71 if [ $VALGRIND = "true" ]
  72 then
  73     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/delete1 2>> $0.valgr
  74 else
  75     ${REL_PATH}/delete1
  76     if [ $? -ne 1 ]
  77     then
  78         exit 100;
  79     fi
  80 fi
  81
  82 echo "Tuples deleted from table"
  83 echo "Case 3: -T option for t1: after removing 1 tuple"
  84 if [ $VALGRIND = "true" ]
  85 then
  86     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1 2>> $0.valgr
  87 else
  88     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1
  89     if [ $? -ne 0 ]
  90     then
  91        exit 3;
  92     fi
  93 fi
  94
  95 echo "Case 4: -I option for idx1 of t1, after removing 1 tuple"
  96 if [ $VALGRIND = "true" ]
  97 then
  98     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I t1idx1  2>> $0.valgr
  99 else
 100     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I t1idx1
 101     if [ $? -ne 0 ]
 102     then
 103        exit 4;
 104     fi
 105 fi
 106
 107 ${REL_PATH}/drop
 108 if [ $? -ne 0 ]
 109 then
 110    exit 100;
 111 fi
 112 echo "Tables and Indexes are dropped"
 113
 114 exit 0