Comparing symbol columns

Community
,
1

Hi,
I am encountering a strange issue when comparing 2 symbol columns. for example:

select * from table1 where symbol1 != symbol2

returns rows where symbol1 is exactly the same value as symbol2. If I cast either one of them to varchar then it works as expected.

select * from table1 where cast(symbol1 as varchar) != symbol2 → works correctly

Am I missing something?

thanks.