test/sql/Join/exp.test052.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;
  30 ---------------------------------------------------------
  31         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  32 ---------------------------------------------------------
  33         100     100     505     100     303     333
  34         100     100     505     100     101     110
  35         100     100     505     100     100     200
  36         100     100     404     444     303     333
  37         100     100     404     444     101     110
  38         100     100     404     444     100     200
  39         100     100     100     110     303     333
  40         100     100     100     110     101     110
  41         100     100     100     110     100     200
  42         303     333     505     100     303     333
  43         303     333     505     100     101     110
  44         303     333     505     100     100     200
  45         303     333     404     444     303     333
  46         303     333     404     444     101     110
  47         303     333     404     444     100     200
  48         303     333     100     110     303     333
  49         303     333     100     110     101     110
  50         303     333     100     110     100     200
  51         505     555     505     100     303     333
  52         505     555     505     100     101     110
  53         505     555     505     100     100     200
  54         505     555     404     444     303     333
  55         505     555     404     444     101     110
  56         505     555     404     444     100     200
  57         505     555     100     110     303     333
  58         505     555     100     110     101     110
  59         505     555     100     110     100     200
  60
  61 echo select * from t2,t1,t3;
  62 ---------------------------------------------------------
  63         t2.f1   t2.f2   t1.f1   t1.f2   t3.f1   t3.f2
  64 ---------------------------------------------------------
  65         505     100     100     100     303     333
  66         505     100     100     100     101     110
  67         505     100     100     100     100     200
  68         505     100     303     333     303     333
  69         505     100     303     333     101     110
  70         505     100     303     333     100     200
  71         505     100     505     555     303     333
  72         505     100     505     555     101     110
  73         505     100     505     555     100     200
  74         404     444     100     100     303     333
  75         404     444     100     100     101     110
  76         404     444     100     100     100     200
  77         404     444     303     333     303     333
  78         404     444     303     333     101     110
  79         404     444     303     333     100     200
  80         404     444     505     555     303     333
  81         404     444     505     555     101     110
  82         404     444     505     555     100     200
  83         100     110     100     100     303     333
  84         100     110     100     100     101     110
  85         100     110     100     100     100     200
  86         100     110     303     333     303     333
  87         100     110     303     333     101     110
  88         100     110     303     333     100     200
  89         100     110     505     555     303     333
  90         100     110     505     555     101     110
  91         100     110     505     555     100     200
  92
  93 echo select * from t3,t1,t2;
  94 ---------------------------------------------------------
  95         t3.f1   t3.f2   t1.f1   t1.f2   t2.f1   t2.f2
  96 ---------------------------------------------------------
  97         303     333     100     100     505     100
  98         303     333     100     100     404     444
  99         303     333     100     100     100     110
 100         303     333     303     333     505     100
 101         303     333     303     333     404     444
 102         303     333     303     333     100     110
 103         303     333     505     555     505     100
 104         303     333     505     555     404     444
 105         303     333     505     555     100     110
 106         101     110     100     100     505     100
 107         101     110     100     100     404     444
 108         101     110     100     100     100     110
 109         101     110     303     333     505     100
 110         101     110     303     333     404     444
 111         101     110     303     333     100     110
 112         101     110     505     555     505     100
 113         101     110     505     555     404     444
 114         101     110     505     555     100     110
 115         100     200     100     100     505     100
 116         100     200     100     100     404     444
 117         100     200     100     100     100     110
 118         100     200     303     333     505     100
 119         100     200     303     333     404     444
 120         100     200     303     333     100     110
 121         100     200     505     555     505     100
 122         100     200     505     555     404     444
 123         100     200     505     555     100     110
 124
 125 Statement Executed
 126 Statement Executed
 127 Statement Executed