4 # 8.load table. csqldump ,
5 # unload table csqldump, insert record to mysql directly,
6 # reload table, csqldump and verify the results.
7 # reload should get the inserted record also.
9 #Run this test only under csql/test or on this directory.
10 #Otherwise, it may fail
13 isql
$DSN < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
14 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
16 input
=${PWD}/cache
/CacheTable
/inputtest4.sql
20 REL_PATH
=${PWD}/cache
/CacheTable
23 isql
$DSN < ${REL_PATH}/inputtest4.sql
>/dev
/null
2>&1
25 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
26 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
28 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
> /dev
/null
2>&1
35 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
36 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
38 $CSQL_INSTALL_ROOT/bin
/csqldump
40 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
41 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
42 echo "1:t1" > /tmp
/csql
/csqltable.conf
43 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-u > /dev
/null
2>&1
50 $CSQL_INSTALL_ROOT/bin
/csqldump
52 isql
$DSN < ${REL_PATH}/insert.sql
>/dev
/null
2>&1
54 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
> /dev
/null
2>&1
61 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
62 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
64 $CSQL_INSTALL_ROOT/bin
/csqldump
66 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
67 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db