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
8 # check pages used(normal and merged) and chunks used for user database
10 #Run this test only under csql/test or on this directory.
11 #Otherwise, it may fail
12 EXECUTABLE
=${PWD}/system
/Allocator
/create
14 if [ -s "$EXECUTABLE" ]
16 REL_PATH
=${PWD}/system
/Allocator
19 echo "Case 1: -d option with no table"
20 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-d
31 echo "Tables and Indexes are created"
33 echo "Case 2: -d option with 1 table"
34 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-d
46 echo "Case 3: -d option after removing table"
47 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-d