Shua42
Databricks Employee
Databricks Employee

I replicated the query exactly but I couldn't produce the same results, and got back the expected result of the single row with 'aaa'. My initial thought is that it could be a bug in the runtime. Can you share the runtime of the cluster you are using?