Skip to Content
1
Former Member
Aug 09, 2016 at 03:42 AM

Trailing whitespace ignored

252 Views

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 1

Since the strings are not the same, I expect to get 2 different results. Is there something I'm missing?