test/sql/Join/exp.test028.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 insert into t1 values(101,100);
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(303,333);
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1 values(505,555);
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t2 values(505,100);
  14 Statement Executed: Rows Affected = 1
  15 echo insert into t2 values(404,444);
  16 Statement Executed: Rows Affected = 1
  17 echo insert into t2 values(101,110);
  18 Statement Executed: Rows Affected = 1
  19 echo insert into t3 values(303,333);
  20 Statement Executed: Rows Affected = 1
  21 echo insert into t3 values(101,110);
  22 Statement Executed: Rows Affected = 1
  23 echo insert into t3 values(222,200);
  24 Statement Executed: Rows Affected = 1
  25 echo select * from t1,t2,t3;
  26 ---------------------------------------------------------
  27         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  28 ---------------------------------------------------------
  29         100     100     505     100     303     333
  30         100     100     505     100     101     110
  31         100     100     505     100     100     200
  32         100     100     404     444     303     333
  33         100     100     404     444     101     110
  34         100     100     404     444     100     200
  35         100     100     100     110     303     333
  36         100     100     100     110     101     110
  37         100     100     100     110     100     200
  38         303     333     505     100     303     333
  39         303     333     505     100     101     110
  40         303     333     505     100     100     200
  41         303     333     404     444     303     333
  42         303     333     404     444     101     110
  43         303     333     404     444     100     200
  44         303     333     100     110     303     333
  45         303     333     100     110     101     110
  46         303     333     100     110     100     200
  47         505     555     505     100     303     333
  48         505     555     505     100     101     110
  49         505     555     505     100     100     200
  50         505     555     404     444     303     333
  51         505     555     404     444     101     110
  52         505     555     404     444     100     200
  53         505     555     100     110     303     333
  54         505     555     100     110     101     110
  55         505     555     100     110     100     200
  56
  57 echo select * from t2,t1,t3;
  58 ---------------------------------------------------------
  59         t2.f1   t2.f2   t1.f1   t1.f2   t3.f1   t3.f2
  60 ---------------------------------------------------------
  61         505     100     100     100     303     333
  62         505     100     100     100     101     110
  63         505     100     100     100     100     200
  64         505     100     303     333     303     333
  65         505     100     303     333     101     110
  66         505     100     303     333     100     200
  67         505     100     505     555     303     333
  68         505     100     505     555     101     110
  69         505     100     505     555     100     200
  70         404     444     100     100     303     333
  71         404     444     100     100     101     110
  72         404     444     100     100     100     200
  73         404     444     303     333     303     333
  74         404     444     303     333     101     110
  75         404     444     303     333     100     200
  76         404     444     505     555     303     333
  77         404     444     505     555     101     110
  78         404     444     505     555     100     200
  79         100     110     100     100     303     333
  80         100     110     100     100     101     110
  81         100     110     100     100     100     200
  82         100     110     303     333     303     333
  83         100     110     303     333     101     110
  84         100     110     303     333     100     200
  85         100     110     505     555     303     333
  86         100     110     505     555     101     110
  87         100     110     505     555     100     200
  88
  89 echo select * from t3,t1,t2;
  90 ---------------------------------------------------------
  91         t3.f1   t3.f2   t1.f1   t1.f2   t2.f1   t2.f2
  92 ---------------------------------------------------------
  93         303     333     100     100     505     100
  94         303     333     100     100     404     444
  95         303     333     100     100     100     110
  96         303     333     303     333     505     100
  97         303     333     303     333     404     444
  98         303     333     303     333     100     110
  99         303     333     505     555     505     100
 100         303     333     505     555     404     444
 101         303     333     505     555     100     110
 102         101     110     100     100     505     100
 103         101     110     100     100     404     444
 104         101     110     100     100     100     110
 105         101     110     303     333     505     100
 106         101     110     303     333     404     444
 107         101     110     303     333     100     110
 108         101     110     505     555     505     100
 109         101     110     505     555     404     444
 110         101     110     505     555     100     110
 111         100     200     100     100     505     100
 112         100     200     100     100     404     444
 113         100     200     100     100     100     110
 114         100     200     303     333     505     100
 115         100     200     303     333     404     444
 116         100     200     303     333     100     110
 117         100     200     505     555     505     100
 118         100     200     505     555     404     444
 119         100     200     505     555     100     110
 120
 121 Statement Executed
 122 Statement Executed
 123 Statement Executed