Hi Julian Hyde : I see. Thank you. Julian Hyde <[email protected]> 于2019年11月6日周三 下午5:32写道：
> First, you need to understand that the purpose of SqlSimpleParser is > to fix partial or badly-formed SQL. For example, if someone has > written > > SELECT 1 AS y, x + > FROM t > WHERE c = > > in an editor then and wants to know completions after 'c = ', first > you need to remove the malformed expression 'x +'. > > So, the purgeXxx methods are trying to remove bad pieces of the SQL. > After they have been removed you should be able to run the results > through a real SQL parser. > > On Tue, Nov 5, 2019 at 7:59 PM 曲修成 <[email protected]> wrote: > > > > Hi All: > > When I use the > org.apache.calcite.sql.advise.SqlSimpleParser.Query#simplify > > ,have a problem： > > > > input sql： > > select id,name from emp > > > > but,output sql > > select * from emp > > > > Because > org.apache.calcite.sql.advise.SqlSimpleParser.Query#purgeSelect，purge > > Select > > > > There are many methods like purgeXXX > > > > Why? >
