test/tools/csql/exp.test136.ksh

   1 echo CREATE TABLE t1(f1 INT DEFAULT 5, f2 INT, PRIMARY KEY(f1));
   2 Statement Executed
   3 echo INSERT INTO t1 VALUES(1,10);
   4 Statement Executed: Rows Affected = 1
   5 echo INSERT INTO t1 VALUES(5,20);
   6 Statement Executed: Rows Affected = 1
   7 echo INSERT INTO t1(f2) VALUES(10);
   8 Statement execute failed with error -21
   9 echo SELECT * FROM t1;
  10 ---------------------------------------------------------
  11         t1.f1   t1.f2
  12 ---------------------------------------------------------
  13         1       10
  14         5       20
  15
  16 Statement Executed