Re: [HACKERS] oid8types() borken?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: oliver(at)fritz(dot)traverse(dot)net (Christopher Oliver)
Cc: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Re: [HACKERS] oid8types() borken?
Date: 1998-09-21 15:42:26
Message-ID: 199809211542.LAA13554@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> Also, I checked through the example given by the Russian contributor:
>
> create table t0 (a_id int4 not null, a varchar, a_t1_id int4);
> insert into t0 values (1, 'at0', 0);
> insert into t0 values (2, 'at0', 0);
> create index a_id_t0 on t0 (a_id);
> create index a_t1_id_t0 on t0 (a_t1_id);
> select * from t0 where (a_id = 1 or a_id = 2) and a_t1_id < 1;
>
> This is crashing in optimizer/util/ordering.c at line 57 trying to
> compute path_ordering1->ord.merge->left_operator because the merge
> field in ord is NULL. No suggestions; this is deeper in the guts
> than I'm qualified to hack just now. ;-)

OK, fixed. There were cases where the ordtype was defaulting to
MERGE_ORDER, while it should have been SORTOP_ORDER. Hence, the
mergejoin fields where being reference when they should not have been.

Your supplied query now works.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle | (610) 353-9879(w)
+ If your life is a hard drive, | (610) 853-3000(h)
+ Christ can be your backup. |

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-09-21 15:45:48 Re: [HACKERS] Errors inside transactions
Previous Message Thomas G. Lockhart 1998-09-21 15:33:40 Re: [HACKERS] union regression test