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