Hi Jeff,
That was fast :-)
I am trying to create a script that reproduces the issue as it seems it is not quite that simple, please bear with me.
datcollate en_US.UTF-8
datctype en_US.UTF-8
SERVER_ENCODING UTF8
CHEERS
Paul
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
PRIVACY & CONFIDENTIALITY NOTICE
The information contained in this email is intended for the named recipients only. It may contain privileged and confidential information and if you are not the intended recipient, you should not copy it or disclose its contents to any other person, or take any action in reliance on it. If you have received this email in error, please notify us immediately by return email.