test/sql/Join/exp.test083.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 Statement Executed
  14 Statement Executed: Rows Affected = 1
  15 Statement Executed: Rows Affected = 1
  16 Statement Executed: Rows Affected = 1
  17 Statement Executed: Rows Affected = 1
  18 Statement Executed: Rows Affected = 1
  19 echo select * from t1;
  20 ---------------------------------------------------------
  21         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
  22 ---------------------------------------------------------
  23         10      100     1000    Bijay   1000.000000     100000.000000   2009/3/1        11:59:59.0      2009/3/1 11:59:59.0
  24         11      110     1100    Jitendr 2000.000000     200000.000000   2009/3/2        11:59:58.0      2009/3/2 11:59:59.0
  25         12      120     1000    Nihar   3000.000000     300000.000000   2009/3/3        11:59:57.0      2009/3/3 11:59:59.0
  26         13      130     1500    Kishor  4000.000000     400000.000000   2009/3/4        11:59:59.0      2009/3/4 11:59:59.0
  27         14      100     1000    Praba   5000.000000     500000.000000   2009/3/1        11:59:58.0      2009/3/1 11:59:59.0
  28
  29 echo select * from t2;
  30 ---------------------------------------------------------
  31         t2.f1   t2.f2   t2.f3   t2.f4   t2.f5   t2.f6   t2.f7   t2.f8   t2.f9
  32 ---------------------------------------------------------
  33         13      110     1100    Sanjit  6000.000000     600000.000000   2009/3/2        11:59:57.0      2009/3/2 11:59:59.0
  34         16      120     1000    Sanjay  6500.000000     700000.000000   2009/3/3        11:59:59.0      2009/3/3 11:59:59.0
  35         17      130     1100    Arindam 8000.000000     800000.000000   2009/3/4        11:59:58.0      2009/3/4 11:59:59.0
  36         10      100     1000    Bijay   9000.000000     900000.000000   2009/3/1        11:59:57.0      2009/3/1 11:59:59.0
  37         11      110     1100    Jitendr 1000.000000     100000.000000   2009/3/2        11:59:58.0      2009/3/2 11:59:59.0
  38
  39 echo select * from t3;
  40 ---------------------------------------------------------
  41         t3.f1   t3.f2   t3.f3   t3.f4   t3.f5   t3.f6   t3.f7   t3.f8   t3.f9
  42 ---------------------------------------------------------
  43         12      120     1000    Nihar   2000.000000     200000.000000   2009/3/3        11:59:56.0      2009/3/3 11:59:59.0
  44         13      130     1100    Kishor  3000.000000     300000.000000   2009/3/5        11:59:56.0      2009/3/5 11:59:59.0
  45         14      100     1000    Praba   4000.000000     400000.000000   2009/3/1        11:59:55.0      2009/3/4 11:59:59.0
  46         15      110     1100    Sanjit  5000.000000     500000.000000   2009/3/2        11:59:56.0      2009/3/1 11:59:59.0
  47         16      120     1000    Sanjay  6000.000000     600000.000000   2009/3/3        11:59:55.0      2009/3/3 11:59:59.0
  48
  49 echo select t1.f1, t1.f2, t2.f1, t2.f2 from t1 inner join t2 on t1.f1 = t2.f1 ;
  50 ---------------------------------------------------------
  51         t1.f1   t1.f2   t2.f1   t2.f2
  52 ---------------------------------------------------------
  53         10      100     10      100
  54         11      110     11      110
  55         13      130     13      110
  56
  57 echo select t1.f1, t1.f2, t2.f1, t2.f2 from t1 inner join t2 on t1.f2 = t2.f2 ;
  58 ---------------------------------------------------------
  59         t1.f1   t1.f2   t2.f1   t2.f2
  60 ---------------------------------------------------------
  61         10      100     10      100
  62         11      110     13      110
  63         11      110     11      110
  64         12      120     16      120
  65         13      130     17      130
  66         14      100     10      100
  67
  68 echo select t1.f1, t1.f3, t2.f1, t2.f3 from t1 inner join t2 on t1.f3 = t2.f3 ;
  69 ---------------------------------------------------------
  70         t1.f1   t1.f3   t2.f1   t2.f3
  71 ---------------------------------------------------------
  72         10      1000    16      1000
  73         10      1000    10      1000
  74         11      1100    13      1100
  75         11      1100    17      1100
  76         11      1100    11      1100
  77         12      1000    16      1000
  78         12      1000    10      1000
  79         14      1000    16      1000
  80         14      1000    10      1000
  81
  82 echo select t1.f1, t1.f4, t2.f1, t2.f4 from t1 inner join t2 on t1.f4 = t2.f4 ;
  83 ---------------------------------------------------------
  84         t1.f1   t1.f4   t2.f1   t2.f4
  85 ---------------------------------------------------------
  86         10      Bijay   10      Bijay
  87         11      Jitendr 11      Jitendr
  88
  89 echo select t1.f1, t1.f5, t2.f1, t2.f5 from t1 inner join t2 on t1.f5 = t2.f5 ;
  90 ---------------------------------------------------------
  91         t1.f1   t1.f5   t2.f1   t2.f5
  92 ---------------------------------------------------------
  93         10      1000.000000     11      1000.000000
  94
  95 echo select t1.f1, t1.f6, t2.f1, t2.f6 from t1 inner join t2 on t1.f6 = t2.f6 ;
  96 ---------------------------------------------------------
  97         t1.f1   t1.f6   t2.f1   t2.f6
  98 ---------------------------------------------------------
  99         10      100000.000000   11      100000.000000
 100
 101 echo select t1.f1, t1.f7, t2.f1, t2.f7 from t1 inner join t2 on t1.f7 = t2.f7 ;
 102 ---------------------------------------------------------
 103         t1.f1   t1.f7   t2.f1   t2.f7
 104 ---------------------------------------------------------
 105         10      2009/3/1        10      2009/3/1
 106         11      2009/3/2        13      2009/3/2
 107         11      2009/3/2        11      2009/3/2
 108         12      2009/3/3        16      2009/3/3
 109         13      2009/3/4        17      2009/3/4
 110         14      2009/3/1        10      2009/3/1
 111
 112 echo select t1.f1, t1.f8, t2.f1, t2.f8 from t1 inner join t2 on t1.f8 = t2.f8 ;
 113 ---------------------------------------------------------
 114         t1.f1   t1.f8   t2.f1   t2.f8
 115 ---------------------------------------------------------
 116         10      11:59:59.0      16      11:59:59.0
 117         11      11:59:58.0      17      11:59:58.0
 118         11      11:59:58.0      11      11:59:58.0
 119         12      11:59:57.0      13      11:59:57.0
 120         12      11:59:57.0      10      11:59:57.0
 121         13      11:59:59.0      16      11:59:59.0
 122         14      11:59:58.0      17      11:59:58.0
 123         14      11:59:58.0      11      11:59:58.0
 124
 125 echo select t1.f1, t1.f9, t2.f1, t2.f9 from t1 inner join t2 on t1.f9 = t2.f9 ;
 126 ---------------------------------------------------------
 127         t1.f1   t1.f9   t2.f1   t2.f9
 128 ---------------------------------------------------------
 129         10      2009/3/1 11:59:59.0     10      2009/3/1 11:59:59.0
 130         11      2009/3/2 11:59:59.0     13      2009/3/2 11:59:59.0
 131         11      2009/3/2 11:59:59.0     11      2009/3/2 11:59:59.0
 132         12      2009/3/3 11:59:59.0     16      2009/3/3 11:59:59.0
 133         13      2009/3/4 11:59:59.0     17      2009/3/4 11:59:59.0
 134         14      2009/3/1 11:59:59.0     10      2009/3/1 11:59:59.0
 135
 136 Statement Executed
 137 Statement Executed
 138 Statement Executed