[Bug] doris 1.2.6 select data from table ,same condition but can't see the result

[niunan2019]

Search before asking

• I had searched in the issues and found no similar issues.

Version

doris 1.2.6

What's Wrong?

select event,date from ods_prod.event_topic
where time ='1689501441651'
and date = '2023-07-16'
and event ='SA_View' # 加入这个条件就查不出数据。去掉就可以。但是这个字段的值就是 SA_View

What You Expected?

如何解决？

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[tudouzhao]

是否可以确认下有无空格之类的字符，导致在相应的mysql快捷工具里看到值，但实际上存储的数据有其他不可见字符

[ixzc]

add this parameter to be.conf: enable_low_cardinality_optimize = false