test/tools/csql/exp.testnw018.ksh

   1 Network CSql
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement execute failed with error -21
   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         6
  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
  22 echo select * from t1 where f1=5 and f2=1;
  23 ---------------------------------------------------------
  24         t1.f1   t1.f2   t1.f3
  25 ---------------------------------------------------------
  26
  27 echo select * from t1 where f1=5;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2   t1.f3
  30 ---------------------------------------------------------
  31         5       2       5
  32
  33 echo select * from t1 where f1=7;
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2   t1.f3
  36 ---------------------------------------------------------
  37
  38 echo select * from t1 where f1=10 and f2=2 and f3=10;
  39 ---------------------------------------------------------
  40         t1.f1   t1.f2   t1.f3
  41 ---------------------------------------------------------
  42         10      2       10
  43
  44 echo select * from t1 where f1=10 and f2=6 and f3=10;
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2   t1.f3
  47 ---------------------------------------------------------
  48
  49 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT  NOT NULL , f3 INT );
  50 CREATE INDEX t1_idx1_Primary on t1 (  f1  ,f2  )  HASH  UNIQUE;
  51 INSERT INTO t1 VALUES(1,1,1);
  52 INSERT INTO t1 VALUES(2,1,2);
  53 INSERT INTO t1 VALUES(3,1,3);
  54 INSERT INTO t1 VALUES(5,2,5);
  55 INSERT INTO t1 VALUES(10,2,10);
  56 INSERT INTO t1 VALUES(100,3,100);
  57 Network CSql
  58 Statement Executed