NLPchina/elasticsearch-sql

无法支持常量结果,能看看怎么回事么?

AqooDer opened this issue · 2 comments

比如:select count(*) as totle,'全系统' as all_sys,1 as state from user where state in(1,8) .
报错如下:Caused by: org.nlpcn.es4sql.exception.SqlParseException: unknown field name : 1
at org.nlpcn.es4sql.parse.FieldMaker.makeField(FieldMaker.java:97)
at org.nlpcn.es4sql.parse.SqlParser.findSelect(SqlParser.java:140)
at org.nlpcn.es4sql.parse.SqlParser.parseSelect(SqlParser.java:88)
at org.nlpcn.es4sql.parse.SqlParser.parseSelect(SqlParser.java:64)
at org.nlpcn.es4sql.query.ESActionFactory.create(ESActionFactory.java:65)
at org.nlpcn.es4sql.SearchDao.explain(SearchDao.java:46)

select count(*) as totle,script("all_sys","'全系统'"),script("state","1") from user where state in(1,8) 

感谢