test/tools/csql/exp.testnw013.ksh

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