Can support where 1 = 1 condition

[120003808]

version:2.3.1
select * FROM myindex where1 = 1

Error: {"error":{"root_cause":[{"type":"sql_parse_exception","reason":"err find condition class com.alibaba.druid.sql.ast.expr.SQLIntegerExpr"}],"type":"sql_parse_exception","reason":"err find condition class com.alibaba.druid.sql.ast.expr.SQLIntegerExpr"},"status":500}

[shi-yuan]

Isn't it select * FROM myindex ?

[120003808]

I want can support
SELECT * FROM wladdress where 1 = 1 (and dynamic condition)

[shi-yuan]

Not supported currently.
But you can use ScriptQuery, like:
SELECT * FROM myindex where script('1 == 1')

[120003808]

Script disabled
Is there any other way？

[shi-yuan]

you can enable script

[120003808]

OK ,thank you

[shi-yuan]

Add script.engine.groovy.inline.search: on to elasticsearch.yml configuration file and restart the node

[120003808]

OK ,IT WORK

[allwefantasy]

select * FROM myindex where1 = 1 is more sql style and SELECT * FROM myindex where script('1 == 1') make newbies confuse . So if es-sql support this future would be more convenience. New pr to fix this issue will be created later.