test/tools/csql/exp.test126.ksh

   1 echo CREATE TABLE t1(f1 int,f2 int,primary key(f1));
   2 Statement Executed
   3 echo CREATE TABLE t2(f1 int NOT NULL,f2 int,foreign key(f1) references t1(f1));
   4 Statement Executed
   5 echo CREATE INDEX idx1 on t2(f1) Hash Unique;
   6 Statement Executed
   7 echo INSERT INTO t1 VALUES(1,10);
   8 Statement Executed: Rows Affected = 1
   9 echo INSERT INTO t2 VALUES(1,10);
  10 Statement Executed: Rows Affected = 1
  11 ---------------------------------------------------------
  12         t1.f1   t1.f2
  13 ---------------------------------------------------------
  14         1       10
  15
  16 ---------------------------------------------------------
  17         t2.f1   t2.f2
  18 ---------------------------------------------------------
  19         1       10
  20
  21 echo INSERT INTO t2 VALUES(1,20);
  22 Statement execute failed with error -21
  23 ---------------------------------------------------------
  24         t1.f1   t1.f2
  25 ---------------------------------------------------------
  26         1       10
  27
  28 ---------------------------------------------------------
  29         t2.f1   t2.f2
  30 ---------------------------------------------------------
  31         1       10
  32
  33 Statement Executed
  34 Statement Executed