Illegal mix of collations for operation UNION

hi @balaji.ramaswamy and team,
I hope you are doing fine. I was here to ask why we are getting this error while running the query. Also, if I try the same queries in the MySQL workbench, they work. is it something collations?

Thank you,
Dhruv Mevada

@mevadadhruv It could be possible that the push down is causing the issue. Are you able to send the profile?