3 # create table with two fields and index on first field
5 # check number of tuples, totalPagesused
6 # check pagesUsed for storing hash bucket
7 # check number of index nodes, pagesUsed for storing index nodes
9 # check number of tuples, totalPagesused
10 # check pagesUsed for storing hash bucket
11 # check number of index nodes, pagesUsed for storing index nodes
13 #Run this test only under csql/test or on this directory.
14 #Otherwise, it may fail
15 EXECUTABLE
=${PWD}/system
/Allocator
/create
17 if [ -s "$EXECUTABLE" ]
19 REL_PATH
=${PWD}/system
/Allocator
22 if [ $VALGRIND = "true" ]
24 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/create
2> $0.valgr
32 echo "Tables and Indexes are created"
34 if [ $VALGRIND = "true" ]
36 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/insert1000
2>> $0.valgr
38 ${REL_PATH}/insert1000
39 echo "Tuples inserted into table"
40 echo "Case 1: -T option for t1: with 1000 tuple"
43 echo "Tables and Indexes are created"
44 if [ $VALGRIND = "true" ]
46 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-T t1
2>> $0.valgr
48 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-T t1
54 echo "Case 2: -I option for idx1 of t1, with 1000 tuple"
55 if [ $VALGRIND = "true" ]
57 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-I t1idx1
2>> $0.valgr
59 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-I t1idx1
66 if [ $VALGRIND = "true" ]
68 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/delete1000
2>> $0.valgr
70 ${REL_PATH}/delete1000
73 echo "Tuples deleted from table"
74 echo "Case 3: -T option for t1: after removing 1000 tuple"
75 if [ $VALGRIND = "true" ]
77 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-T t1
2>> $0.valgr
79 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-T t1
85 echo "Case 4: -I option for idx1 of t1, after removing 1000 tuple"
86 if [ $VALGRIND = "true" ]
88 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-I t1idx1
2>> $0.valgr
90 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-I t1idx1
101 echo "Tables and Indexes are dropped"