2 # Create Tree indexes on the fields which are (TINYINT,SMALLINT,INT,BIGINT,CHAR,VARCHAR,DATE,TIME).
3 # CREATE TABLE t1(f1 TINYINT ,f2 SMALLINT ,f3 INT ,f4 BIGINT ,f5 CHAR(20) ,f6 VARCHAR(30) ,f7 FLOAT ,f8 DOUBLE ,f9 DATE ,f10 TIME ,f11 TIMESTAMP);
4 # CREATE INDEX idxtiny ON t1(f1) TREE;
5 # CREATE INDEX idxsmall ON t1(f2) TREE;
6 # CREATE INDEX idxint ON t1(f3) TREE;
7 # CREATE INDEX idxbig ON t1(f4) TREE;
8 # CREATE INDEX idxchar ON t1(f5) TREE;
9 # CREATE INDEX idxvarchar ON t(f6) TREE;
10 # CREATE INDEX idxfloat ON t1(f7) TREE;
11 # CREATE INDEX idxdouble ON t1(f8) TREE;
12 # CREATE INDEX idxdate ON t(f9) TREE;
13 # CREATE INDEX idxtime ON t1(f10) TREE;
14 # CREATE INDEX idxtimestamp ON t1(f11) TREE;
15 # All the indexes needs to be created
17 FILE
=${PWD}/sqlapi
/Csql
/DDLStmt
/treeindexonalldatatypen
21 REL_PATH
=`pwd`/sqlapi
/Csql
/DDLStmt
24 if [ "$VALGRIND" = "true" ]
26 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/treeindexonalldatatypen
28 $REL_PATH/treeindexonalldatatypen
31 if [ "$VALGRIND" = "true" ]
33 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
35 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
38 echo "echo drop table t1;" >${REL_PATH}/drop_t1.sql
39 echo "drop table t1;" >>${REL_PATH}/drop_t1.sql
41 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t1.sql
42 rm -f ${REL_PATH}/drop_t1.sql