test/tools/csql/exp.test026.ksh

   1 echo double 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 echo select * from t1;
  10 ---------------------------------------------------------
  11         t1.f1   t1.f2
  12 ---------------------------------------------------------
  13         0.107374        10.234000
  14         -0.107374       11.234000
  15         12.234000       11.456000
  16         13.123000       11.987000
  17         14.467000       12.123000
  18         50.345000       10.234000
  19
  20 echo select * from t1 where f1 BETWEEN 0.1073741822 AND 0.1073741824
  21 select * from t1 where  f1 BETWEEN 0.1073741822 AND 0.1073741824;
  22 echo select * from t1 where f1 BETWEEN -0.1073741824 AND -0.1073741822
  23 select * from t1 where  f1 BETWEEN -0.1073741824 AND -0.1073741822;
  24 echo select * from t1 where f2 < f1;
  25 ---------------------------------------------------------
  26         t1.f1   t1.f2
  27 ---------------------------------------------------------
  28         12.234000       11.456000
  29         13.123000       11.987000
  30         14.467000       12.123000
  31         50.345000       10.234000
  32
  33 echo update t1 set f2 = 3.4345 where f2 >11;
  34 Statement Executed: Rows Affected = 4
  35 ---------------------------------------------------------
  36         t1.f1   t1.f2
  37 ---------------------------------------------------------
  38         0.107374        10.234000
  39         -0.107374       3.433500
  40         12.234000       3.433500
  41         13.123000       3.433500
  42         14.467000       3.433500
  43         50.345000       10.234000
  44
  45 echo delete from t1 where f1 > 14.234;
  46 Statement Executed: Rows Affected = 2
  47 ---------------------------------------------------------
  48         t1.f1   t1.f2
  49 ---------------------------------------------------------
  50         0.107374        10.234000
  51         -0.107374       3.433500
  52         12.234000       3.433500
  53         13.123000       3.433500
  54
  55 Statement Executed