Doing the following query:
select 'wat ' as x from dummy
union
select 'wat' as x from dummy
In other words, I'm doing a union on two rows, where one value has a trailing whitespace.
This is what I get back:
x count(*) wat 1Since the strings are not the same, I expect to get 2 different results. Is there something I'm missing?