BUG #8352: Using UPPER in ON clause of JOIN

On 08/02/2013 01:48 AM, dyuen@rbauction.com wrote:

The following bug has been logged on the website:

Bug reference: 8352
Logged by: Daisy
Email address: dyuen@rbauction.com
PostgreSQL version: 9.2.4
Operating system: Windows 7
Description:

When joining two tables on a varchar column wrapped in a upper statement,
the join does not work if there is a trailing space in both of the varchar
values.

In the two examples below, VALUE1 and VALUE2 = "ABC "

-- Doesn't work

SELECT * FROM TABLE1 INNER JOIN TABLE2 ON UPPER(VALUE1) = UPPER(VALUE2)

-- Works

SELECT * FROM TABLE1 INNER JOIN TABLE2 ON UPPER(TRIM(VALUE1)) =
UPPER(TRIM(VALUE2))

I am unable to reproduce this. Can you provide a self-contained example
please?

Vik

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs