test/tools/csql/exp.testnw020.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 execute failed with error -21
   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         6
  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
  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 CHAR (12) NOT NULL , f3 INT );
  51 CREATE INDEX idx on t1 (  f1  ,f2  )  HASH  UNIQUE;
  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(5, '2',5);
  56 INSERT INTO t1 VALUES(10, '2',10);
  57 INSERT INTO t1 VALUES(100, '3',100);
  58 Network CSql
  59 Statement Executed