test/tools/csql/exp.test031.ksh

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