3 # 7. For the above scenario,
4 # delete 3 tuples from csql and
5 # delete 2 tuples from mysql.
6 # Run $ cacheverify -t t1.
7 # The output should display number of records as 7 and 8 for csql and
9 # Run $ cacheverify -t t1 -p.
10 # The output should display the primary key field values for missing
11 # records in either of the databases in ascending order.
12 # Run $ cacheverify -t t1 -f.
13 # The output should display the records are consistent for the same
16 #Run this test only under csql/test or on this directory.
17 #Otherwise, it may fail
19 input
=${PWD}/cache
/CacheVerify
/csqldelete.sql
23 REL_PATH
=${PWD}/cache
/CacheVerify
26 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/csqldelete.sql
>/dev
/null
2>&1
32 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
33 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
34 isql
$DSN < ${REL_PATH}/mysqldelete.sql
>/dev
/null
2>&1
37 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
41 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
44 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
48 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-p
51 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
55 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-f
58 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
62 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE