[GitHub] [druid] Gahen edited a comment on issue #10525: Incorrect results (including nulls) when querying string column with col <> '' and col is not null

[GitBox <gi...@apache.org>]

Gahen edited a comment on issue #10525:
URL: https://github.com/apache/druid/issues/10525#issuecomment-719056162


   We'd also notice this issue to when filtering doing an SQL query like `SELECT * FROM some_table WHERE some_string_field IS NOT NULL AND (NOT some_string_field = 'some value')  GROUP BY some_string_field`. 
   
   The `EXPLAIN PLAN FOR` seems to show that druid discards the "not null" clause when parsing the SQL as it's the exact same when removing the `some_string_field IS NOT NULL AND` part.
   
   One workaround for us was to use `LIKE` instead of `IS`


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org