test/tools/csql/exp.test025.ksh

   1 echo float data type testing;
   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 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 echo select * from t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2
  14 ---------------------------------------------------------
  15         0.104857        10.234000
  16         -0.104857       11.234000
  17         12.234000       11.456000
  18         13.123000       11.987000
  19         14.467000       12.123000
  20         50.345001       10.234000
  21         123456.000000   10.234000
  22         123.456001      10.234000
  23
  24 echo select * from t1 where f1 BETWEEN 0.104856 AND 0.104858
  25 select * from t1 where  f1 BETWEEN 0.104856 AND 0.104858;
  26 echo select * from t1 where f1 >122 AND f1 <124;
  27 ---------------------------------------------------------
  28         t1.f1   t1.f2
  29 ---------------------------------------------------------
  30         123.456001      10.234000
  31
  32 echo select * from t1 where f1 BETWEEN -0.104859 AND -0.104856
  33 select * from t1 where  f1 BETWEEN -0.104859 AND -0.104856;
  34 echo select * from t1 where f1 BETWEEN -124 AND -122
  35 select * from t1 where  f1 BETWEEN  -124 AND -122;
  36 echo select * from t1 where f2 < f1;
  37 ---------------------------------------------------------
  38         t1.f1   t1.f2
  39 ---------------------------------------------------------
  40         12.234000       11.456000
  41         13.123000       11.987000
  42         14.467000       12.123000
  43         50.345001       10.234000
  44         123456.000000   10.234000
  45         123.456001      10.234000
  46
  47 echo update t1 set f2 = 3.4345 where f2 >11;
  48 Statement Executed: Rows Affected = 4
  49 ---------------------------------------------------------
  50         t1.f1   t1.f2
  51 ---------------------------------------------------------
  52         0.104857        10.234000
  53         -0.104857       3.433500
  54         12.234000       3.433500
  55         13.123000       3.433500
  56         14.467000       3.433500
  57         50.345001       10.234000
  58         123456.000000   10.234000
  59         123.456001      10.234000
  60
  61 echo delete from t1 where f1 > 14.234;
  62 Statement Executed: Rows Affected = 4
  63 ---------------------------------------------------------
  64         t1.f1   t1.f2
  65 ---------------------------------------------------------
  66         0.104857        10.234000
  67         -0.104857       3.433500
  68         12.234000       3.433500
  69         13.123000       3.433500
  70
  71 Statement Executed