4 # 9.create table t1 (f1 int, f2 int) in mysql and
5 # create table t1 (f1 int, f2 int, f3 int) in csql.
6 # load with no definition option. should fail.
8 #Run this test only under csql/test or on this directory.
9 #Otherwise, it may fail
12 rm -f /tmp
/csql
/csqltable.conf
13 touch /tmp
/csql
/csqltable.conf
14 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
15 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
19 input
=${PWD}/cache
/CacheTable
/inputtest4.sql
23 REL_PATH
=${PWD}/cache
/CacheTable
26 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
27 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
28 DS
="$DSN $DBUSER $PASSWORD"
29 rm -f /tmp
/csql
/csqlds.conf
30 touch /tmp
/csql
/csqlds.conf
31 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
34 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
38 echo CACHE_TABLE
=true
>>$CSQL_CONFIG_FILE
39 echo "Inserting table t1 with records in targetDB"
40 isql
$DS < ${REL_PATH}/inputtest4.sql
2>/dev
/null
42 rm -f /tmp
/csql
/csqltable.conf
43 touch /tmp
/csql
/csqltable.conf
45 echo "Creating the same table t1 in csql without records"
46 if [ "$DSN" = "oracle" ]
48 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqlinputtest9oracle.sql
50 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqlinputtest9.sql
55 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
59 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectt1.sql
63 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
67 echo "Caching the table with -s (only load records)"
68 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-s
72 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
76 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectt1.sql
80 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
85 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE