horaedb
horaedb copied to clipboard
Select function(scalar) return error
Describe this problem
Currently, select function(scalar) will return err like
Failed to execute query, err: Server(ServerError { code: 500, msg: "Failed to execute interpreter, query: SELECT NOT(1);. Caused by: Failed to execute select, err:Failed to execute logical plan, err:Failed to do logical optimization, err:DataFusion Failed to optimize logical plan, err:Internal error: NOT 'Literal { value: Int64(1) }' can't be evaluated because the expression's type is Int64, not boolean or NULL. This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker." })
Steps to reproduce
Execute this SQL
SELECT NOT(1);
Expected behavior
It should work without error
Additional Information
- https://github.com/CeresDB/ceresdb/blob/334bc6ce13aac2e72a0771419b4aefe2164255e9/tests/cases/00_dummy/select_1.result#L11
- https://github.com/CeresDB/ceresdb/issues/123
ref #154