adding test scripts
[csql.git] / test / cache / CacheTable / test007.ksh
blob049198b9abd00899c356e12eb428647eb989100f
1 #!/bin/ksh
2 # Test Case
4 # 7.Do not create table, load with no definition option. should fail.
6 #Run this test only under csql/test or on this directory.
7 #Otherwise, it may fail
9 input=${PWD}/cache/CacheTable/inputtest4.sql
10 REL_PATH=.
11 if [ -s "$input" ]
12 then
13 REL_PATH=${PWD}/cache/CacheTable
16 cp $CSQL_CONFIG_FILE /tmp/csql.conf
17 echo CACHE_TABLE=true >>$CSQL_CONFIG_FILE
18 echo DSN=$DSN >>$CSQL_CONFIG_FILE
19 DS="$DSN $DBUSER $PASSWORD"
20 rm -f /tmp/csql/csqlds.conf
21 touch /tmp/csql/csqlds.conf
22 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
23 if [ $? -ne 0 ]
24 then
25 cp /tmp/csql.conf $CSQL_CONFIG_FILE
26 exit 1;
29 isql $DS < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
31 rm -f /tmp/csql/csqltable.conf
32 touch /tmp/csql/csqltable.conf
34 ret=1
35 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -s > /dev/null 2>&1
36 if [ $? -ne 0 ]
37 then
38 ret=0;
40 isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
41 rm -f /tmp/csql/csqltable.conf
42 touch /tmp/csql/csqltable.conf
43 cp /tmp/csql.conf $CSQL_CONFIG_FILE
44 exit $ret;