ErrorMessage{errorCode=1267, sqlState='HY000', errorMessage='Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb4_general_ci,COERCIBLE) for operation '=''}
when trying to perform a query with the folowing WHERE clause
WHERE concat(column1, cast(column2 as char)) = 'some-string',
The query works when using WHERE column1 = 'some-string' or WHERE cast(column2 as char) = 'some-string'.
The query works in standard SQL client using JDBC.
I am getting exception
ErrorMessage{errorCode=1267, sqlState='HY000', errorMessage='Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb4_general_ci,COERCIBLE) for operation '=''} when trying to perform a query with the folowing WHERE clause WHERE concat(column1, cast(column2 as char)) = 'some-string',
The query works when using WHERE column1 = 'some-string' or WHERE cast(column2 as char) = 'some-string'.
The query works in standard SQL client using JDBC.