Re: ERROR: left and right pathkeys do not match in mergejoin

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR: left and right pathkeys do not match in mergejoin
Date: 2018-02-23 18:48:47
Message-ID: 13940.1519411727@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> writes:
> In create_mergejoin_plan:
>     * implied inner ordering is then "ORDER BY x, y, x", but the pathkey
>     * drops the second sort by x as redundant, and this code must cope.
> -- should this read "the pathkey machinery drops"?

I changed that and improved some other comments, and pushed it.
Thanks for reviewing!

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-02-23 18:52:00 Re: Allow workers to override datallowconn
Previous Message Magnus Hagander 2018-02-23 18:35:42 Re: Online enabling of checksums