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 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
34 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
35 DS
="$DSN $DBUSER $PASSWORD"
36 rm -f /tmp
/csql
/csqlds.conf
37 touch /tmp
/csql
/csqlds.conf
38 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
44 if [ $DSN = "oracle" ]
46 isql
$DS < ${REL_PATH}/oracleupdate.sql
>/dev
/null
2>&1
49 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
55 isql
$DS < ${REL_PATH}/db2update.sql
>/dev
/null
2>&1
58 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
62 isql
$DS < ${REL_PATH}/mysqlupdate.sql
>/dev
/null
2>&1
65 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
71 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
74 rm -f /tmp
/csql
/csqltable.conf
75 touch /tmp
/csql
/csqltable.conf
76 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
80 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-p
83 rm -f /tmp
/csql
/csqltable.conf
84 touch /tmp
/csql
/csqltable.conf
85 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
89 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-f
92 rm -f /tmp
/csql
/csqltable.conf
93 touch /tmp
/csql
/csqltable.conf
94 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
98 rm -f /tmp
/csql
/csqltable.conf
99 touch /tmp
/csql
/csqltable.conf
100 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
101 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
>/dev
/null
2>&1