test/tools/csql/exp.test002.ksh

   1 echo create table and constraints with integer fields;
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 ---------------------------------------------------------
   9         t1.f1   t1.f2
  10 ---------------------------------------------------------
  11         10      20
  12         11      21
  13         12      22
  14         13      NULL
  15         NULL    24
  16
  17 Statement Executed
  18 Statement Executed: Rows Affected = 1
  19 Statement Executed: Rows Affected = 1
  20 Statement Executed: Rows Affected = 1
  21 Statement Executed: Rows Affected = 1
  22 Statement execute failed with error -22
  23 ---------------------------------------------------------
  24         t2.f1   t2.f2
  25 ---------------------------------------------------------
  26         10      20
  27         11      21
  28         12      22
  29         13      NULL
  30
  31 Statement Executed
  32 Statement Executed: Rows Affected = 1
  33 Statement Executed: Rows Affected = 1
  34 Statement Executed: Rows Affected = 1
  35 Statement Executed: Rows Affected = 1
  36 Statement execute failed with error -22
  37 Statement Executed: Rows Affected = 1
  38 Statement Executed: Rows Affected = 1
  39 Statement prepare failed with error -19
  40 ---------------------------------------------------------
  41         t3.f1   t3.f2
  42 ---------------------------------------------------------
  43         10      NULL
  44         11      21
  45         12      22
  46         13      NULL
  47         100     NULL
  48
  49 Statement Executed
  50 Statement Executed
  51 Statement Executed