test/tools/csql/exp.test122.ksh

   1 echo CREATE TABLE t1(f1 int,f2 int,f3 int,primary key(f1,f2));
   2 Statement Executed
   3 echo CREATE TABLE t2(f1 int,f2 int,f3 int,foreign key(f1,f3) references t1(f1,f2));
   4 Statement Executed
   5 echo INSERT INTO t1 VALUES(1,10,100);
   6 Statement Executed: Rows Affected = 1
   7 echo INSERT INTO t1 VALUES(1,20,100);
   8 Statement Executed: Rows Affected = 1
   9 echo INSERT INTO t1 VALUES(3,20,100);
  10 Statement Executed: Rows Affected = 1
  11 echo INSERT INTO t1 VALUES(4,30,300);
  12 Statement Executed: Rows Affected = 1
  13 echo SELECT * FROM t1;
  14 ---------------------------------------------------------
  15         t1.f1   t1.f2   t1.f3
  16 ---------------------------------------------------------
  17         1       10      100
  18         1       20      100
  19         3       20      100
  20         4       30      300
  21
  22 echo INSERT INTO t2 VALUES(1,1000,10);
  23 Statement Executed: Rows Affected = 1
  24 echo INSERT INTO t2 VALUES(1,1000,20);
  25 Statement Executed: Rows Affected = 1
  26 echo INSERT INTO t2 VALUES(1,1000,10);
  27 Statement Executed: Rows Affected = 1
  28 echo INSERT INTO t2 VALUES(4,1000,30);
  29 Statement Executed: Rows Affected = 1
  30 echo SELECT * FROM t2;
  31 ---------------------------------------------------------
  32         t2.f1   t2.f2   t2.f3
  33 ---------------------------------------------------------
  34         1       1000    10
  35         1       1000    20
  36         1       1000    10
  37         4       1000    30
  38
  39 echo UPDATE t2 SET f1=3,f3=20 WHERE f1=1;
  40 Statement Executed: Rows Affected = 3
  41 echo SELECT * FROM t2;
  42 ---------------------------------------------------------
  43         t2.f1   t2.f2   t2.f3
  44 ---------------------------------------------------------
  45         3       1000    20
  46         3       1000    20
  47         3       1000    20
  48         4       1000    30
  49
  50 echo UPDATE t2 SET f3=20 WHERE f1=4;
  51 Statement execute failed with error -34
  52 Statement Executed
  53 Statement Executed