2 # Hash Index, Unique Hash Index
3 # create table t1 (f1 varchar(10), f2 smallint);
4 # create table t2 (f1 varchar(10), f2 smallint);
5 # create index idx1 on t1(f1)hash;
6 # create index idx2 on t2(f1)hash unique;
7 # insert records into both the tables.
8 # t2.f1 field should not allow duplicate records.
10 CREATEFILE
=${PWD}/sql
/Datatype
/csql.conf
12 if [ -s "$CREATEFILE" ]
14 REL_PATH
=`pwd`/sql
/Datatype
17 echo "drop table t1;" >${REL_PATH}/drop.sql
18 echo "drop table t2;" >>${REL_PATH}/drop.sql
20 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
>/dev
/null
2>&1
22 if [ "$VALGRIND" = "true" ]
24 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_hash.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_hash.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
30 rm -f ${REL_PATH}/drop.sql
35 if [ "$VALGRIND" = "true" ]
37 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
39 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
42 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
48 rm -f ${REL_PATH}/drop.sql