3 #Run this test only under csql/test or on this directory.
4 #Otherwise, it may fail
6 # mysql is not connecting becos odbc.ini does not have anything.
7 # try to cache the table created in target db
10 CSQL_CONF
=${PWD}/cache
/Recovery
/csql.conf
12 if [ -s "$CSQL_CONF" ]
14 REL_PATH
=${PWD}/cache
/Recovery
18 cp $REL_PATH/csql.conf
/tmp
19 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
21 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
22 DS
="$DSN $DBUSER $PASSWORD"
24 rm -f /tmp
/csql
/csqlds.conf
25 touch /tmp
/csql
/csqlds.conf
26 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
33 isql
$DS < $REL_PATH/drop.sql
> /dev
/null
2>&1
34 isql
$DS < $REL_PATH/createt1.sql
> /dev
/null
2>&1
40 rm -f /tmp
/csql
/csqltable.conf
41 touch /tmp
/csql
/csqltable.conf
43 echo "1 t1 NULL NULL NULL $DSN" > /tmp
/csql
/csqltable.conf
49 rm -f /tmp
/csql
/csqlds.conf
50 touch /tmp
/csql
/csqlds.conf
51 $CSQL_INSTALL_ROOT/bin
/csqlserver
-c >/dev
/null
2>&1
55 rm -f /tmp
/csql
/csqlds.conf
56 touch /tmp
/csql
/csqlds.conf
57 isql
$DS < $REL_PATH/drop.sql
> /dev
/null
2>&1
61 rm -f /tmp
/csql
/csqlds.conf
62 touch /tmp
/csql
/csqlds.conf
63 isql
$DS < $REL_PATH/drop.sql
> /dev
/null
2>&1