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