Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15475: Views over CITEXT columns return no data - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #15475: Views over CITEXT columns return no data
Date
Msg-id CAMkU=1yLn+JJy5Sc_H76yJ+9yFrrbuQ+L4PdcUPNMq-SOCxMTg@mail.gmail.com
Whole thread Raw
In response to BUG #15475: Views over CITEXT columns return no data  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15475: Views over CITEXT columns return no data
List pgsql-bugs
Tree view
On Wed, Oct 31, 2018 at 6:45 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15475
Logged by:          Paul Schaap
Email address:      ps@ipggroup.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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15475: Views over CITEXT columns return no data
Next
From: Paul Schaap
Date:
Subject: Re: BUG #15475: Views over CITEXT columns return no data