test/tools/csql/test090.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # create table t1(f1 int,f2 int,f3 int,primary key(f1,f2));
   4 # insert duplicate values in composite key field. It should be failed.
   5 # create table t1(f1 int,f2 int,f3 int,primary key(f1,f3));
   6 # insert duplicate values in composite key field. It should be failed.
   7 # create table t1(f1 int,f2 int,f3 int,f4 int,primary key(f2,f4));
   8 # insert duplicate values in composite key field. It should be failed.
   9 #
  10 QUITFILE=${PWD}/tools/csql/quit.sql
  11 REL_PATH=.
  12 if [ -s "$QUITFILE" ]
  13 then
  14     REL_PATH=`pwd`/tools/csql
  15 fi
  16
  17 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/composite1.sql
  18 if [ $? -ne 0 ]
  19 then
  20    exit 1;
  21 fi
  22 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/composite2.sql
  23 if [ $? -ne 0 ]
  24 then
  25    exit 1;
  26 fi
  27 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/composite3.sql
  28 if [ $? -ne 0 ]
  29 then
  30    exit 1;
  31 fi