3 # 9. Create table t1 in mysql with primary key. Insert 10 rows.
4 # Cache the table in csql.
5 # Update 2 rows in csql and 2 rows in mysql with different primary keys.
6 # Run $ cacheverify -t t1.
7 # The output should display number of records as 10 for both csql and
9 # Run $ cacheverify -t t1 -p.
10 # The output should display no missing records in either of the
12 # Run $ cacheverify -t t1 -f.
13 # The output should display the 4 inconsistent records.
14 # Only those fields with different values should be displayed
15 # for inconsistent records.
17 #Run this test only under csql/test or on this directory.
18 #Otherwise, it may fail
20 input
=${PWD}/cache
/CacheVerify
/mysqlinput.sql
24 REL_PATH
=${PWD}/cache
/CacheVerify
27 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
28 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
29 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
30 DS
="$DSN $DBUSER $PASSWORD"
31 rm -f /tmp
/csql
/csqlds.conf
32 touch /tmp
/csql
/csqlds.conf
33 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
38 if [ $DSN = "myodbc3" ]
40 isql
$DS < ${REL_PATH}/mysqlinput.sql
>/dev
/null
2>&1
45 elif [ "$DSN" = "oracle" ]
47 isql
$DS < ${REL_PATH}/oracleinput.sql
>/dev
/null
2>&1
52 elif [ "$DSN" = "sybase" ]
54 isql
$DS < ${REL_PATH}/oracleinput.sql
>/dev
/null
2>&1
59 elif [ "$DSN" = "db2" ]
61 isql
$DS < ${REL_PATH}/db2input.sql
>/dev
/null
2>&1
67 isql
$DS < ${REL_PATH}/psqlinput.sql
>/dev
/null
2>&1
74 if [ "$DSN" = "oracle" ]
76 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqloracleinput.sql
>/dev
/null
2>&1
79 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
83 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/mysqlinput.sql
>/dev
/null
2>&1
86 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
90 echo "1 t1 NULL NULL NULL $DSN" > /tmp
/csql
/csqltable.conf
93 if [ "$DSN" = "oracle" ]
95 isql
$DS < ${REL_PATH}/oracleupdate.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
106 isql
$DS < ${REL_PATH}/db2update.sql
>/dev
/null
2>&1
109 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
113 isql
$DS < ${REL_PATH}/mysqlupdate.sql
>/dev
/null
2>&1
116 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
122 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqlupdate.sql
>/dev
/null
2>&1
125 rm -f /tmp
/csql
/csqltable.conf
126 touch /tmp
/csql
/csqltable.conf
127 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
131 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
135 rm -f /tmp
/csql
/csqltable.conf
136 touch /tmp
/csql
/csqltable.conf
137 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
141 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-p
144 rm -f /tmp
/csql
/csqltable.conf
145 touch /tmp
/csql
/csqltable.conf
146 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
150 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-f
153 rm -f /tmp
/csql
/csqltable.conf
154 touch /tmp
/csql
/csqltable.conf
155 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
159 rm -f /tmp
/csql
/csqltable.conf
160 touch /tmp
/csql
/csqltable.conf
161 isql
$DS < $REL_PATH/drop.sql
>/dev
/null
2>&1
162 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
>/dev
/null
2>&1