4 # 10. Create table t1 with primary key in csql and insert 10 tuples.
5 # Create the same table in mysql and add 10 tuples with different
7 # Add entry for table t1 in csqltable.conf file.
8 # Now run $ csqlverify -t t1 -p.
9 # The output should be displayed without any error.
11 #Run this test only under csql/test or on this directory.
12 #Otherwise, it may fail
14 input
=${PWD}/cache
/CacheVerify
/mysqlinput.sql
18 REL_PATH
=${PWD}/cache
/CacheVerify
21 rm -f /tmp
/csql
/csqltable.conf
22 touch /tmp
/csql
/csqltable.conf
24 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
25 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
26 isql
$DSN < ${REL_PATH}/mysqlinput.sql
>/dev
/null
2>&1
29 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqlinput.sql
>/dev
/null
2>&1
36 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
40 echo "1:t1 NULL NULL NULL" > /tmp
/csql
/csqltable.conf
42 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
45 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
49 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-p
52 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
56 $CSQL_INSTALL_ROOT/bin
/cacheverify
-t t1
-f
59 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
63 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
>/dev
/null
2>&1
64 isql
$DSN < $REL_PATH/drop.sql
>/dev
/null
2>&1
66 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE