test/cache/CacheVerify/test003.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # 3. Run cacheverify on a non existing table.
   4 #    It should give an error saying the table is not present.
   5
   6 cp $CSQL_CONFIG_FILE /tmp/csql.conf
   7 export CSQL_CONFIG_FILE=/tmp/csql.conf
   8 DS="$DSN $DBUSER $PASSWORD"
   9 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  10 rm -f /tmp/csql/csqlds.conf
  11 touch /tmp/csql/csqlds.conf
  12 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  13 if [ $? -ne 0 ]
  14 then
  15    exit 1;
  16 fi
  17 $CSQL_INSTALL_ROOT/bin/cacheverify -t not_exists > /dev/null 2>&1
  18 if [ $? -eq 0 ]
  19 then
  20    exit 1;
  21 fi
  22
  23 exit 0;
  24