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