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
27 echo "Tables and Indexes are created"
33 echo "Tuples inserted into table"
34 echo "Case 1: -T option for t1: with 100 tuple"
35 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-T t1
41 echo "Case 2: -I option for idx1 of t1, with 100 tuple"
42 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-I t1idx1
50 echo "Tuples deleted from table"
51 echo "Case 3: -T option for t1: after removing all tuple"
52 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-T t1
58 echo "Case 4: -I option for idx1 of t1, after removing all tuple"
59 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-I t1idx1
70 echo "Tables and Indexes are dropped"