test/tools/csql/exp.testnw019.ksh

   1 Network CSql
   2 Statement Executed
   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 echo select count(f1) from t1;
  12 ---------------------------------------------------------
  13         COUNT(f1)
  14 ---------------------------------------------------------
  15         7
  16
  17 echo select * from t1 where f1=1 and f2=1;
  18 ---------------------------------------------------------
  19         t1.f1   t1.f2   t1.f3
  20 ---------------------------------------------------------
  21         1       1       1
  22         1       1       3
  23
  24 echo select * from t1 where f1=5 and f2=1;
  25 ---------------------------------------------------------
  26         t1.f1   t1.f2   t1.f3
  27 ---------------------------------------------------------
  28
  29 echo select * from t1 where f1=5;
  30 ---------------------------------------------------------
  31         t1.f1   t1.f2   t1.f3
  32 ---------------------------------------------------------
  33         5       2       5
  34
  35 echo select * from t1 where f1=7;
  36 ---------------------------------------------------------
  37         t1.f1   t1.f2   t1.f3
  38 ---------------------------------------------------------
  39
  40 echo select * from t1 where f1=10 and f2=2 and f3=10;
  41 ---------------------------------------------------------
  42         t1.f1   t1.f2   t1.f3
  43 ---------------------------------------------------------
  44         10      2       10
  45
  46 echo select * from t1 where f1=10 and f2=6 and f3=10;
  47 ---------------------------------------------------------
  48         t1.f1   t1.f2   t1.f3
  49 ---------------------------------------------------------
  50
  51 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT  NOT NULL , f3 INT );
  52 CREATE INDEX idx on t1 (  f1  ,f2  )  HASH ;
  53 INSERT INTO t1 VALUES(1,1,1);
  54 INSERT INTO t1 VALUES(2,1,2);
  55 INSERT INTO t1 VALUES(3,1,3);
  56 INSERT INTO t1 VALUES(1,1,3);
  57 INSERT INTO t1 VALUES(5,2,5);
  58 INSERT INTO t1 VALUES(10,2,10);
  59 INSERT INTO t1 VALUES(100,3,100);
  60 Network CSql
  61 Statement Executed