test/tools/csql/exp.test030.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement execute failed with error -21
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 echo select count(f1) from t1;
  10 ---------------------------------------------------------
  11         COUNT(f1)
  12 ---------------------------------------------------------
  13         6
  14
  15 echo select * from t1 where f1=1 and f2=1;
  16 ---------------------------------------------------------
  17         t1.f1   t1.f2   t1.f3
  18 ---------------------------------------------------------
  19         1       1       1
  20
  21 echo select * from t1 where f1=5 and f2=1;
  22 ---------------------------------------------------------
  23         t1.f1   t1.f2   t1.f3
  24 ---------------------------------------------------------
  25
  26 echo select * from t1 where f1=5;
  27 ---------------------------------------------------------
  28         t1.f1   t1.f2   t1.f3
  29 ---------------------------------------------------------
  30         5       2       5
  31
  32 echo select * from t1 where f1=7;
  33 ---------------------------------------------------------
  34         t1.f1   t1.f2   t1.f3
  35 ---------------------------------------------------------
  36
  37 echo select * from t1 where f1=10 and f2=2 and f3=10;
  38 ---------------------------------------------------------
  39         t1.f1   t1.f2   t1.f3
  40 ---------------------------------------------------------
  41         10      2       10
  42
  43 echo select * from t1 where f1=10 and f2=6 and f3=10;
  44 ---------------------------------------------------------
  45         t1.f1   t1.f2   t1.f3
  46 ---------------------------------------------------------
  47
  48 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT  NOT NULL , f3 INT );
  49 CREATE INDEX t1_idx1_Primary on t1 (  f1  ,f2  )  HASH  UNIQUE;
  50 INSERT INTO t1 VALUES(1,1,1);
  51 INSERT INTO t1 VALUES(2,1,2);
  52 INSERT INTO t1 VALUES(3,1,3);
  53 INSERT INTO t1 VALUES(5,2,5);
  54 INSERT INTO t1 VALUES(10,2,10);
  55 INSERT INTO t1 VALUES(100,3,100);
  56 Statement Executed