test/tools/copystmt/test002.ksh

   1 #!/bin/ksh
   2 #create table t1 with f1 int and f2 char(20). insert 10 different record.
   3 #create table ct1 with f1 int ,f2 char(20)
   4 #create table ct2 with f1 int
   5 #create table ct3 with f1 char(20)
   6 # a. insert into ct1 as select * from t1;
   7 # b. insert into ct2 as select f1 from t1;
   8 # c.insert into ct3 as select f2 from t1;
   9 # Drop all tables.
  10 QUITFILE=${PWD}/tools/copystmt/quit.sql
  11 REL_PATH=.
  12 if [ -s "$QUITFILE" ]
  13 then
  14     REL_PATH=`pwd`/tools/copystmt
  15 fi
  16
  17 echo "echo create table t1(f1 int,f2 char(20));" >${REL_PATH}/create_t1.sql
  18 echo "create table t1(f1 int,f2 char(20));" >>${REL_PATH}/create_t1.sql
  19 i=1
  20 while [ $i -le 10 ]
  21 do
  22   echo "insert into t1 values($i,'CSQL$i');" >>${REL_PATH}/create_t1.sql
  23   i=`expr $i + 1`
  24 done
  25
  26 echo "echo create table ct1 (f1 int, f2 char(20));" >${REL_PATH}/create_ct1.sql
  27 echo "create table ct1 (f1 int, f2 char(20));"     >>${REL_PATH}/create_ct1.sql
  28
  29 echo "echo create table ct2(f1 int);" >${REL_PATH}/create_ct2.sql
  30 echo "create table ct2(f1 int);"     >>${REL_PATH}/create_ct2.sql
  31
  32 echo "echo create table ct3(f1 char(20));" >${REL_PATH}/create_ct3.sql
  33 echo "create table ct3(f1 char(20));"     >>${REL_PATH}/create_ct3.sql
  34
  35 echo "echo insert into ct1 as select * from t1;" >${REL_PATH}/insertinto_ct1.sql
  36 echo "insert into ct1 as select * from t1;"     >>${REL_PATH}/insertinto_ct1.sql
  37
  38 echo "echo insert into ct2 as select f1 from t1;" >${REL_PATH}/insertinto_ct2.sql
  39 echo "insert into ct2 as select f1 from t1;"     >>${REL_PATH}/insertinto_ct2.sql
  40
  41 echo "echo insert into ct3 as select f2 from t1;" >${REL_PATH}/insertinto_ct3.sql
  42 echo "insert into ct3 as select f2 from t1;"     >>${REL_PATH}/insertinto_ct3.sql
  43
  44 echo "Drop table t1;"  >${REL_PATH}/drop.sql
  45 echo "Drop table ct1;">>${REL_PATH}/drop.sql
  46 echo "Drop table ct2;">>${REL_PATH}/drop.sql
  47 echo "Drop table ct3;">>${REL_PATH}/drop.sql
  48
  49 if [ "$VALGRIND" = "true" ]
  50 then
  51     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_t1.sql 2> $0.valgr
  52 else
  53     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_t1.sql
  54     if [ $? -ne 0 ]
  55     then
  56        echo Failed
  57        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
  58        exit 1;
  59     fi
  60 fi
  61
  62 if [ "$VALGRIND" = "true" ]
  63 then
  64     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_ct1.sql 2>> $0.valgr
  65 else
  66     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_ct1.sql
  67     if [ $? -ne 0 ]
  68     then
  69        echo Failed
  70        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
  71        exit 2;
  72     fi
  73 fi
  74
  75 if [ "$VALGRIND" = "true" ]
  76 then
  77     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_ct2.sql 2>> $0.valgr
  78 else
  79     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_ct2.sql
  80     if [ $? -ne 0 ]
  81     then
  82        echo Failed
  83        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
  84        exit 3;
  85     fi
  86 fi
  87
  88 if [ "$VALGRIND" = "true" ]
  89 then
  90     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_ct3.sql 2>> $0.valgr
  91 else
  92     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_ct3.sql
  93     if [ $? -ne 0 ]
  94     then
  95        echo Failed
  96        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
  97        exit 4;
  98     fi
  99 fi
 100
 101 if [ "$VALGRIND" = "true" ]
 102 then
 103     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertinto_ct1.sql 2>> $0.valgr
 104 else
 105     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertinto_ct1.sql
 106     if [ $? -ne 0 ]
 107     then
 108        echo Failed
 109        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
 110        exit 5;
 111     fi
 112 fi
 113
 114 if [ "$VALGRIND" = "true" ]
 115 then
 116     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertinto_ct2.sql 2>> $0.valgr
 117 else
 118     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertinto_ct2.sql
 119     if [ $? -ne 0 ]
 120     then
 121        echo Failed
 122        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
 123        exit 6;
 124     fi
 125 fi
 126
 127 if [ "$VALGRIND" = "true" ]
 128 then
 129     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertinto_ct3.sql 2>> $0.valgr
 130 else
 131     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertinto_ct3.sql
 132     if [ $? -ne 0 ]
 133     then
 134        echo Failed
 135        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
 136        exit 7;
 137     fi
 138 fi
 139
 140 if [ "$VALGRIND" = "true" ]
 141 then
 142     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 143 else
 144     $CSQL_INSTALL_ROOT/bin/csqldump
 145     if [ $? -ne 0 ]
 146     then
 147        echo Failed
 148        rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
 149        exit 8;
 150     fi
 151 fi
 152
 153 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
 154 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
 155 echo passed
 156 exit 0;