Re: BUG #4748: hash join and sort-merge join make different results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4748: hash join and sort-merge join make different results
Date
Msg-id 7889.1238819520@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4748: hash join and sort-merge join make different results  (Roman Kononov <kononov@ftml.net>)
Responses Re: BUG #4748: hash join and sort-merge join make different results  (Roman Kononov <kononov@ftml.net>)
List pgsql-bugs
Roman Kononov <kononov@ftml.net> writes:
> On 2009-04-03 14:57 Tom Lane said the following:
>> I think we could fix this by having interval_hash() duplicate the
>> total-span calculation done by interval_cmp_internal, and then return
>> the hash of the resulting TimeOffset.  This is going to break existing
>> hash indexes on intervals, but there seems little choice...

> Consider hashing the result of justify_interval().

Uh, what's your point?  We have to match interval_eq, not
justify_interval.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Roman Kononov
Date:
Subject: Re: BUG #4748: hash join and sort-merge join make different results
Next
From: Tom Lane
Date:
Subject: Re: BUG #4748: hash join and sort-merge join make different results