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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #15475: Views over CITEXT columns return no data
Дата
Msg-id CAMkU=1yLn+JJy5Sc_H76yJ+9yFrrbuQ+L4PdcUPNMq-SOCxMTg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15475: Views over CITEXT columns return no data  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #15475: Views over CITEXT columns return no data  (Paul Schaap <ps@ipggroup.com>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15475: Views over CITEXT columns return no data
Следующее
От: Paul Schaap
Дата:
Сообщение: Re: BUG #15475: Views over CITEXT columns return no data