test/tools/csql/exp.testnw002.ksh

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