2 # Create Hash 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) HASH;
5 # CREATE INDEX idxsmall ON t1(f2) HASH;
6 # CREATE INDEX idxint ON t1(f3) HASH;
7 # CREATE INDEX idxbig ON t1(f4) HASH;
8 # CREATE INDEX idxchar ON t1(f5) HASH;
9 # CREATE INDEX idxvarchar ON t(f6) HASH;
10 # CREATE INDEX idxdate ON t1(f7) HASH;
11 # CREATE INDEX idxtime ON t1(f8) HASH;
12 # All the indexes needs to be created
14 FILE
=${PWD}/sqlapi
/Csql
/DDLStmt
/hashindexonalldatatype
18 REL_PATH
=`pwd`/sqlapi
/Csql
/DDLStmt
21 if [ "$VALGRIND" = "true" ]
23 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/hashindexonalldatatype
25 $REL_PATH/hashindexonalldatatype
28 if [ "$VALGRIND" = "true" ]
30 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
32 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
35 echo "echo drop table t1;" >${REL_PATH}/drop_t1.sql
36 echo "drop table t1;" >>${REL_PATH}/drop_t1.sql
38 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t1.sql
39 rm -f ${REL_PATH}/drop_t1.sql