test/cache/CacheVerify/test005.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # 5. Create table t1 with primary key in csql.
   4 #    Make sure that t1 is not present in mysql and
   5 #    csqltable.conf file does not have any entry for t1.
   6 #    run $ cacheverify -t t1.
   7 #    It should give an error saying table t1 is not cached.
   8
   9 #Run this test only under csql/test or on this directory.
  10 #Otherwise, it may fail
  11
  12 input=${PWD}/cache/CacheVerify/mysqlinput.sql
  13 REL_PATH=.
  14 if [ -s "$input" ]
  15 then
  16     REL_PATH=${PWD}/cache/CacheVerify
  17 fi
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/mysqlinput.sql >/dev/null 2>&1
  20 if [ $? -ne 0 ]
  21 then
  22     exit 1;
  23 fi
  24
  25 rm -f /tmp/csql/csqltable.conf
  26 touch /tmp/csql/csqltable.conf
  27
  28 $CSQL_INSTALL_ROOT/bin/cacheverify -t t1
  29 if [ $? -ne 5 ]
  30 then
  31     exit 2;
  32 fi
  33
  34 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql >/dev/null 2>&1
  35 exit 0;