String Comparison Seems Wrong

[carltal]

Affected Version

V29 and V33

Description

Hi team, it seems that Druid does not compare String character by character. Please see the following 2 screenshots for examples:

The first one shows that I am comparing event_business_date column, which only has date, not time, with a date time String; the result clearly is incorrect.

The second one shows that I am comparing event_business_date column, which only has date, not time, with a date String; the result here is correct.

Is Druid not doing character by character String comparison by default?

Thank you.