test/system/Allocator/test006.ksh

   1 #!/bin/sh
   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 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  21 if [ $? -ne 0 ]
  22 then
  23    exit 1;
  24 fi
  25
  26 ${REL_PATH}/create
  27 if [ $? -ne 0 ]
  28 then
  29    exit 100;
  30 fi
  31 echo "Tables and Indexes are created"
  32
  33 echo "Case 2: -d option with 1 table"
  34 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  35 if [ $? -ne 0 ]
  36 then
  37    exit 1;
  38 fi
  39
  40 ${REL_PATH}/drop
  41 if [ $? -ne 0 ]
  42 then
  43    exit 100;
  44 fi
  45
  46 echo "Case 3: -d option after removing table"
  47 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  48 if [ $? -ne 0 ]
  49 then
  50    exit 3;
  51 fi
  52
  53 exit 0