2 # Composite key(HASH) on varchar with other types.
3 # Create table t1(f1 tinyint, f2 smallint, f3 int, f4 bigint, f5 char(10), f6 varchar(10), f7 float, f8 double,f9 Date, f10 Time, f11 Timestamp);
4 # create index hashidxtinyvar on t1(f1, f6);
5 # create index hashidxsmallvar on t1(f2, f6);
6 # create index hashidxvarint on t1(f6, f3);
7 # create index hashidxvarbig on t1(f6, f4);
8 # create index hashidxcharvar on t1(f5, f6);
9 # create index hashidxvardate on t1(f6, f9);
10 # create index hashidxvartime on t1(f6, f10);
11 # create index hashidxvarfloat on t1(f6, f7); should be fail.
12 # create index hashidxvardouble on t1(f6, f8); should be fail.
13 # create index hashidxvartimestamp on t1(f6, f11); should be fail.
14 # Run catalog tool for check the indexes are made properly or not.
16 CREATEFILE
=${PWD}/sql
/Datatype
/csql.conf
18 if [ -s "$CREATEFILE" ]
20 REL_PATH
=`pwd`/sql
/Datatype
23 echo "drop table t1;" >${REL_PATH}/dropt1.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
>/dev
/null
2>&1
27 if [ "$VALGRIND" = "true" ]
29 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_compindex.sql
31 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_compindex.sql
34 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
35 rm -f ${REL_PATH}/dropt1.sql
40 if [ "$VALGRIND" = "true" ]
42 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
44 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
47 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
53 rm -f ${REL_PATH}/dropt1.sql