test/sql/Join/exp.test007.ksh

   1 echo select * from t11 where t11.f1=2;
   2 ---------------------------------------------------------
   3         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5
   4 ---------------------------------------------------------
   5         2       Y       sales   6000    20
   6
   7 echo select * from t11 where t11.f1=t11.f1;
   8 ---------------------------------------------------------
   9         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5
  10 ---------------------------------------------------------
  11         1       X       IT      5000    10
  12         2       Y       sales   6000    20
  13         3       Z       IT      7000    10
  14