Thread: Assertion failure in indxpath.c

Assertion failure in indxpath.c

From
Heikki Linnakangas
Date:
I'm getting an assertion failure on a fresh git checkout with this query:

create table foo (a int4, b text);CREATE TABLE
create index i_foo on foo (b, a);CREATE INDEX
select * from foo where a = 0 and (b = 'foo' or b = 'bar');

TRAP: FailedAssertion("!(((((const Node*)(ipath))->type) == 
T_IndexPath))", File: "indxpath.c", Line: 1328)

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


Re: Assertion failure in indxpath.c

From
Thom Brown
Date:
On 26 April 2012 17:32, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> I'm getting an assertion failure on a fresh git checkout with this query:
>
> create table foo (a int4, b text);CREATE TABLE
> create index i_foo on foo (b, a);CREATE INDEX
> select * from foo where a = 0 and (b = 'foo' or b = 'bar');
>
> TRAP: FailedAssertion("!(((((const Node*)(ipath))->type) == T_IndexPath))",
> File: "indxpath.c", Line: 1328)

This was broken by 5b7b5518d0ea56c422a197875f7efa5deddbb388

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5b7b5518d0ea56c422a197875f7efa5deddbb388

-- 
Thom


Re: Assertion failure in indxpath.c

From
Tom Lane
Date:
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> I'm getting an assertion failure on a fresh git checkout with this query:
> create table foo (a int4, b text);CREATE TABLE
> create index i_foo on foo (b, a);CREATE INDEX
> select * from foo where a = 0 and (b = 'foo' or b = 'bar');

> TRAP: FailedAssertion("!(((((const Node*)(ipath))->type) == 
> T_IndexPath))", File: "indxpath.c", Line: 1328)

Mph.  Looks like we need a bit more code there (and maybe some more
regression test coverage :-().  Will fix.
        regards, tom lane