test/tools/csql/exp.test124.ksh

   1 echo CREATE TABLE t1(f1 int,f2 int,primary key(f1));
   2 Statement Executed
   3 echo CREATE TABLE t2(f3 int,f4 int,primary key(f3));
   4 Statement Executed
   5 echo CREATE TABLE t3(f5 int,f6 int,foreign key(f5) references t1(f1),foreign key(f6) references t2(f3) );
   6 Statement Executed
   7 echo INSERT INTO t1 values(1,10);
   8 Statement Executed: Rows Affected = 1
   9 echo INSERT INTO t1 values(2,20);
  10 Statement Executed: Rows Affected = 1
  11 echo INSERT INTO t2 values(3,30);
  12 Statement Executed: Rows Affected = 1
  13 echo INSERT INTO t2 values(4,40);
  14 Statement Executed: Rows Affected = 1
  15 echo INSERT INTO t3 values(1,3);
  16 Statement Executed: Rows Affected = 1
  17 echo INSERT INTO t3 values(1,4);
  18 Statement Executed: Rows Affected = 1
  19 echo INSERT INTO t3 values(2,3);
  20 Statement Executed: Rows Affected = 1
  21 echo INSERT INTO t3 values(2,4);
  22 Statement Executed: Rows Affected = 1
  23 echo INSERT INTO t3 values(2,4);
  24 Statement Executed: Rows Affected = 1
  25 echo INSERT INTO t3 values(1,5);
  26 Statement execute failed with error -35
  27 echo SELECT * FROM t1;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2
  30 ---------------------------------------------------------
  31         1       10
  32         2       20
  33
  34 echo SELECT * FROM t2;
  35 ---------------------------------------------------------
  36         t2.f3   t2.f4
  37 ---------------------------------------------------------
  38         3       30
  39         4       40
  40
  41 echo SELECT * FROM t3;
  42 ---------------------------------------------------------
  43         t3.f5   t3.f6
  44 ---------------------------------------------------------
  45         1       3
  46         1       4
  47         2       3
  48         2       4
  49         2       4
  50
  51 echo DELETE FROM t3;
  52 Statement Executed: Rows Affected = 5
  53 echo DELETE FROM t2;
  54 Statement Executed: Rows Affected = 2
  55 echo DELETE FROM t1;
  56 Statement Executed: Rows Affected = 2
  57 echo SELECT * FROM t1;
  58 ---------------------------------------------------------
  59         t1.f1   t1.f2
  60 ---------------------------------------------------------
  61
  62 echo SELECT * FROM t2;
  63 ---------------------------------------------------------
  64         t2.f3   t2.f4
  65 ---------------------------------------------------------
  66
  67 echo SELECT * FROM t3;
  68 ---------------------------------------------------------
  69         t3.f5   t3.f6
  70 ---------------------------------------------------------
  71
  72 Statement Executed
  73 Statement Executed
  74 Statement Executed