The following bug has been logged on the website:
Bug reference: 18117
Logged by: Ariel Mashraki
Email address: ariel(at)mashraki(dot)co(dot)il
PostgreSQL version: 16.0
Operating system: Mac
Description:
I'm not sure if this change was intentional since it wasn't mentioned in the
release notes, or at least, I couldn't find it there. Running the three
statements below in version 16 produces ~different results from those in all
versions before 16. I checked this against versions 11, 12, ... 15
Statements:
create table t(c int);
create view v(c) as select c from t;
select view_definition from information_schema.views where table_name='v';
Result in previous versions:
SELECT t.c FROM t;
Result in the latest version:
SELECT c FROM t;