Re: BUG #15475: Views over CITEXT columns return no data

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Paul Schaap <ps(at)ipggroup(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15475: Views over CITEXT columns return no data
Date: 2018-11-02 00:07:11
Message-ID: 87ftwk4a50.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Paul" == Paul Schaap <ps(at)ipggroup(dot)com> writes:

Paul> Hi Andrew,
Paul> Here you go:

This is looking like a bug in parallel hash. Do the queries all work if
you do set enable_parallel_hash=false; ?

(Going by the row counts in the explains, you got the first two "broken"
and "working" ones backwards)

--
Andrew.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2018-11-02 00:26:06 Re: BUG #15460: Error while creating index or constraint
Previous Message Michael Paquier 2018-11-01 23:58:04 Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition