test/tools/csql/exp.test118.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 t2 VALUES(1,10,100);
   8 Statement execute failed with error -34
   9 echo INSERT INTO t2 VALUES(2,20,10);
  10 Statement execute failed with error -34
  11 Statement Executed
  12 Statement Executed