test/sql/Join/exp.test053.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) tree;
   8 Statement Executed
   9 echo create index idx2 on t2(f1) hash;
  10 Statement Executed
  11 echo insert into t1 values(101,100);
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t1 values(303,333);
  14 Statement Executed: Rows Affected = 1
  15 echo insert into t1 values(505,555);
  16 Statement Executed: Rows Affected = 1
  17 echo insert into t2 values(505,100);
  18 Statement Executed: Rows Affected = 1
  19 echo insert into t2 values(404,444);
  20 Statement Executed: Rows Affected = 1
  21 echo insert into t2 values(101,110);
  22 Statement Executed: Rows Affected = 1
  23 echo insert into t3 values(303,333);
  24 Statement Executed: Rows Affected = 1
  25 echo insert into t3 values(101,110);
  26 Statement Executed: Rows Affected = 1
  27 echo insert into t3 values(222,200);
  28 Statement Executed: Rows Affected = 1
  29 echo select * from t1,t2,t3 where t1.f1 = t2.f1;
  30 ---------------------------------------------------------
  31         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  32 ---------------------------------------------------------
  33         100     100     100     110     303     333
  34         100     100     100     110     101     110
  35         100     100     100     110     100     200
  36         505     555     505     100     303     333
  37         505     555     505     100     101     110
  38         505     555     505     100     100     200
  39
  40 echo select * from t2,t1,t3 where t1.f1 = t2.f1;
  41 ---------------------------------------------------------
  42         t2.f1   t2.f2   t1.f1   t1.f2   t3.f1   t3.f2
  43 ---------------------------------------------------------
  44         505     100     505     555     303     333
  45         505     100     505     555     101     110
  46         505     100     505     555     100     200
  47         100     110     100     100     303     333
  48         100     110     100     100     101     110
  49         100     110     100     100     100     200
  50
  51 echo select * from t3,t1,t2 where t1.f1 = t2.f1;
  52 ---------------------------------------------------------
  53         t3.f1   t3.f2   t1.f1   t1.f2   t2.f1   t2.f2
  54 ---------------------------------------------------------
  55         303     333     100     100     100     110
  56         303     333     505     555     505     100
  57         101     110     100     100     100     110
  58         101     110     505     555     505     100
  59         100     200     100     100     100     110
  60         100     200     505     555     505     100
  61
  62 Statement Executed
  63 Statement Executed
  64 Statement Executed