qpmodel outputName_ shall only be used in ORDER BY|GROUP BY not WHERE|HAVING

outputName_ shall only be used in ORDER BY|GROUP BY not WHERE|HAVING

Open zhouqingqing opened this issue 4 years ago • 4 comments

Dec 30 '19 20:12 zhouqingqing

related #18

Dec 31 '19 23:12 zhouqingqing

This one is working.

select a.a1 aa1, b.b2 bb2 from a join b on(a.a3 = b.b4) where aa1 = bb2 group by aa1, bb2 order by aa1 desc

Unhandled exception. qpmodel.logic.SemanticAnalyzeException: can't bind column 'aa1' to table

Could you point me to an example of it not working, if there is one?

Aug 06 '20 22:08 pkommoju

not sure - we might have fixed it along the way. We can add more test cases for this and close the bug.

Aug 06 '20 22:08 zhouqingqing

Alright, I will add few more test cases and if things look good, I will update the case.

Aug 06 '20 23:08 pkommoju