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

On Wed, Oct 31, 2018 at 6:45 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15475
> Logged by: Paul Schaap
> Email address: ps(at)ipggroup(dot)com
> PostgreSQL version: 11.0
> Operating system: OSX 10.14 and Ubuntu 18.10
> Description:
>
> The steps to reproduce are:
> 1) Install CITEXT extension
> 2) Create a table with a CITEXT column
> 3) Create a view (not materialised) over the table
> 4) Query the view filtering on the CITEXT column
>
> No data gets returned when querying via the view, this works under
> Postgresql 10 but not 11.
>
>
There is no step here where you populate the table.

Add one, I can't reproduce this (on Ubuntu 16.04, so maybe that is
important).

create extension citext ;
create table j1 (x citext);
insert into j1 values ('abc');
create view j2 as select * from j1;
select * from j2 where x ='aBc';

<see a row>

What are your encoding, collation, and ctype?

Cheers,

Jeff