test/tools/csql/test051.ksh

   1 #!/bin/sh
   2 # TEST CASE
   3 #create table t1(f1 int not null,f2 int,f3 int);
   4 #create multiple tree index on the same table by taking different combination of fields
   5 #create index idx1 on t1(f1) tree;
   6 #create index idx2 on t1(f2) tree;
   7 #create index idx3 on t1(f3) tree;
   8 #create index idx4 on t1(f1,f2) tree;
   9 #create index idx5 on t1(f2,f3) tree;
  10 #create index idx6 on t1(f3,f1) tree;
  11 #create index idx7 on t1(f1,f2,f3) tree;
  12 #all should work fine.
  13 #
  14 QUITFILE=${PWD}/tools/csql/quit.sql
  15 REL_PATH=.
  16 if [ -s "$QUITFILE" ]
  17 then
  18     REL_PATH=`pwd`/tools/csql
  19 fi
  20 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/tree7.sql
  21 if [ $? -ne 0 ]
  22 then
  23     exit 1;
  24 fi
  25 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  26 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  27 if [ $? -ne 0 ]
  28 then
  29     exit 2;
  30 fi
  31 exit 0;