test/tools/csql/exp.test101.ksh

   1 echo create table t1(f1 int);
   2 Statement Executed
   3 echo insert into t1 values(10);
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(100a);
   6 Statement prepare failed with error -16
   7 echo update t1 set f1=10a;
   8 Statement prepare failed with error -16
   9 echo update t1 set f1=100a;
  10 Statement prepare failed with error -16
  11 echo update t1 f1=100 where f1=10a;
  12 Statement prepare failed with error -19
  13 echo select * from t1;
  14 ---------------------------------------------------------
  15         t1.f1
  16 ---------------------------------------------------------
  17         10
  18
  19 echo select * from t1 where f1=10a;
  20 Statement prepare failed with error -16
  21 echo drop table t1;
  22 Statement Executed
  23 echo create table t1(f1 tinyint);
  24 Statement Executed
  25 echo insert into t1 values(10);
  26 Statement Executed: Rows Affected = 1
  27 echo insert into t1 values(100a);
  28 Statement prepare failed with error -16
  29 echo update t1 set f1=10a;
  30 Statement prepare failed with error -16
  31 echo update t1 set f1=100a;
  32 Statement prepare failed with error -16
  33 echo update t1 f1=100 where f1=10a;
  34 Statement prepare failed with error -19
  35 echo select * from t1;
  36 ---------------------------------------------------------
  37         t1.f1
  38 ---------------------------------------------------------
  39         10
  40
  41 echo select * from t1 where f1=10a;
  42 Statement prepare failed with error -16
  43 echo drop table t1;
  44 Statement Executed
  45 echo create table t1(f1 smallint);
  46 Statement Executed
  47 echo insert into t1 values(10);
  48 Statement Executed: Rows Affected = 1
  49 echo insert into t1 values(100a);
  50 Statement prepare failed with error -16
  51 echo update t1 set f1=10a;
  52 Statement prepare failed with error -16
  53 echo update t1 set f1=100a;
  54 Statement prepare failed with error -16
  55 echo update t1 f1=100 where f1=10a;
  56 Statement prepare failed with error -19
  57 echo select * from t1;
  58 ---------------------------------------------------------
  59         t1.f1
  60 ---------------------------------------------------------
  61         10
  62
  63 echo select * from t1 where f1=10a;
  64 Statement prepare failed with error -16
  65 echo drop table t1;
  66 Statement Executed
  67 echo create table t1(f1 bigint);
  68 Statement Executed
  69 echo insert into t1 values(10);
  70 Statement Executed: Rows Affected = 1
  71 echo insert into t1 values(100a);
  72 Statement prepare failed with error -16
  73 echo update t1 set f1=10a;
  74 Statement prepare failed with error -16
  75 echo update t1 set f1=100a;
  76 Statement prepare failed with error -16
  77 echo update t1 f1=100 where f1=10a;
  78 Statement prepare failed with error -19
  79 echo select * from t1;
  80 ---------------------------------------------------------
  81         t1.f1
  82 ---------------------------------------------------------
  83         10
  84
  85 echo select * from t1 where f1=10a;
  86 Statement prepare failed with error -16
  87 echo drop table t1;
  88 Statement Executed
  89 echo create table t1(f1 real);
  90 Statement Executed
  91 echo insert into t1 values(10);
  92 Statement Executed: Rows Affected = 1
  93 echo insert into t1 values(100a);
  94 Statement Executed: Rows Affected = 1
  95 echo update t1 set f1=10a;
  96 Statement Executed: Rows Affected = 2
  97 echo update t1 set f1=100a;
  98 Statement Executed: Rows Affected = 2
  99 echo update t1 f1=100 where f1=10a;
 100 Statement prepare failed with error -19
 101 echo select * from t1;
 102 ---------------------------------------------------------
 103         t1.f1
 104 ---------------------------------------------------------
 105         100.000000
 106         100.000000
 107
 108 echo select * from t1 where f1=10a;
 109 ---------------------------------------------------------
 110         t1.f1
 111 ---------------------------------------------------------
 112
 113 echo drop table t1;
 114 Statement Executed
 115 echo create table t1(f1 float);
 116 Statement Executed
 117 echo insert into t1 values(10);
 118 Statement Executed: Rows Affected = 1
 119 echo insert into t1 values(100a);
 120 Statement Executed: Rows Affected = 1
 121 echo update t1 set f1=10a;
 122 Statement Executed: Rows Affected = 2
 123 echo update t1 set f1=100a;
 124 Statement Executed: Rows Affected = 2
 125 echo update t1 f1=100 where f1=10a;
 126 Statement prepare failed with error -19
 127 echo select * from t1;
 128 ---------------------------------------------------------
 129         t1.f1
 130 ---------------------------------------------------------
 131         100.000000
 132         100.000000
 133
 134 echo select * from t1 where f1=10a;
 135 ---------------------------------------------------------
 136         t1.f1
 137 ---------------------------------------------------------
 138
 139 echo drop table t1;
 140 Statement Executed