test/sql/Join/exp.test059.ksh

   1 echo create table t1(f1 int,f2 int);
   2 Statement Executed
   3 echo create table t2(f1 int,f2 int);
   4 Statement Executed
   5 echo create table t3(f1 int,f2 int);
   6 Statement Executed
   7 echo create index idx1 on t1(f1) hash;
   8 Statement Executed
   9 echo create index idx2 on t2(f1) hash;
  10 Statement Executed
  11 echo create index idx3 on t3(f1) hash;
  12 Statement Executed
  13 echo create index idx4 on t1(f2) tree;
  14 Statement Executed
  15 echo create index idx5 on t2(f2) tree;
  16 Statement Executed
  17 echo create index idx6 on t3(f2) tree;
  18 Statement Executed
  19 echo insert into t1 values(101,100);
  20 Statement Executed: Rows Affected = 1
  21 echo insert into t1 values(303,333);
  22 Statement Executed: Rows Affected = 1
  23 echo insert into t1 values(505,555);
  24 Statement Executed: Rows Affected = 1
  25 echo insert into t2 values(505,100);
  26 Statement Executed: Rows Affected = 1
  27 echo insert into t2 values(404,444);
  28 Statement Executed: Rows Affected = 1
  29 echo insert into t2 values(101,110);
  30 Statement Executed: Rows Affected = 1
  31 echo insert into t3 values(303,333);
  32 Statement Executed: Rows Affected = 1
  33 echo insert into t3 values(101,110);
  34 Statement Executed: Rows Affected = 1
  35 echo insert into t3 values(222,200);
  36 Statement Executed: Rows Affected = 1
  37 echo select * from t1,t2,t3 where t1.f1 = t2.f1;
  38 ---------------------------------------------------------
  39         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  40 ---------------------------------------------------------
  41         100     100     100     110     303     333
  42         100     100     100     110     101     110
  43         100     100     100     110     100     200
  44         505     555     505     100     303     333
  45         505     555     505     100     101     110
  46         505     555     505     100     100     200
  47
  48 echo select * from t2,t1,t3 where t1.f1 = t2.f1;
  49 ---------------------------------------------------------
  50         t2.f1   t2.f2   t1.f1   t1.f2   t3.f1   t3.f2
  51 ---------------------------------------------------------
  52         505     100     505     555     303     333
  53         505     100     505     555     101     110
  54         505     100     505     555     100     200
  55         100     110     100     100     303     333
  56         100     110     100     100     101     110
  57         100     110     100     100     100     200
  58
  59 echo select * from t3,t1,t2 where t1.f1 = t2.f1;
  60 ---------------------------------------------------------
  61         t3.f1   t3.f2   t1.f1   t1.f2   t2.f1   t2.f2
  62 ---------------------------------------------------------
  63         303     333     100     100     100     110
  64         303     333     505     555     505     100
  65         101     110     100     100     100     110
  66         101     110     505     555     505     100
  67         100     200     100     100     100     110
  68         100     200     505     555     505     100
  69
  70 Statement Executed
  71 Statement Executed
  72 Statement Executed