horaedb icon indicating copy to clipboard operation
horaedb copied to clipboard

Select function(scalar) return error

Open jiacai2050 opened this issue 3 years ago • 0 comments

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

jiacai2050 avatar Jul 22 '22 06:07 jiacai2050