4 # 8. For the previous scenario update 2 rows in csql and update 2 rows in mysql with different primary keys.
5 # Run $ cacheverify -t t1.
6 # The output should display number of records as 7 and 8 for csql
7 # and mysql respectively.
8 # Run $ cacheverify -t t1 -p.
9 # The output should display the primary key field values for missing
10 # records in either of the databases in ascending order.
11 # Run $ cacheverify -t t1 -f.
12 # The output should display the 4 inconsistent records. Only those
13 # fields with different values should be displayed for inconsistent
16 #Run this test only under csql/test or on this directory.
17 #Otherwise, it may fail
19 input
=${PWD}/cache
/CacheVerify
/csqlupdate.sql
23 REL_PATH
=${PWD}/cache
/CacheVerify
26 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/csqlupdate.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}/mysqlupdate.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 rm -f /tmp
/csql
/csqltable.conf
63 touch /tmp
/csql
/csqltable.conf
64 isql
$DSN < $REL_PATH/drop.sql
>/dev
/null
2>&1
65 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
>/dev
/null
2>&1
67 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE