test/tools/csql/exp.testnw014.ksh

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