AW: [HACKERS] SELECT BUG - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject AW: [HACKERS] SELECT BUG
Date
Msg-id 37CF8025.588AD500@telecom.at
Whole thread Raw
Responses Re: AW: [HACKERS] SELECT BUG
List pgsql-hackers
> But if it is correct, then we need to turn off oprcanhash for bpchareq.
> Odd that no one has noticed this before.

Currently it works for constants, because they are blank padded.
It does not work for the char(8) = char(16) comparison with two
table columns.

Eighter the hash function for bpchar itself should be trailing blank 
insensitive, or the bpchar would need to be padded or truncated before 
computing the hash.

Andreas


pgsql-hackers by date:

Previous
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] Postgres' lexer
Next
From: José Soares
Date:
Subject: Re: [HACKERS] SELECT BUG