pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #18117: View definitions were changed in version 16 (missing column qualifiers) 2+ messages / 2 participants [nested] [flat]
* BUG #18117: View definitions were changed in version 16 (missing column qualifiers) @ 2023-09-20 09:08 PG Bug reporting form <noreply@postgresql.org> 2023-09-20 14:20 ` Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers) Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2023-09-20 09:08 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: ariel@mashraki.co.il The following bug has been logged on the website: Bug reference: 18117 Logged by: Ariel Mashraki Email address: ariel@mashraki.co.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; ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers) 2023-09-20 09:08 BUG #18117: View definitions were changed in version 16 (missing column qualifiers) PG Bug reporting form <noreply@postgresql.org> @ 2023-09-20 14:20 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-09-20 14:20 UTC (permalink / raw) To: ariel@mashraki.co.il; +Cc: pgsql-bugs@lists.postgresql.org PG Bug reporting form <noreply@postgresql.org> writes: > 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'; Yeah, that was intentional, cf https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=47bb9db75 I don't see any corresponding entry in the v16 release notes, but it doesn't surprise me that Bruce would have deemed this an internal change not worth documenting. Minor cosmetic changes in the output of view deparsing are very common. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-09-20 14:20 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-09-20 09:08 BUG #18117: View definitions were changed in version 16 (missing column qualifiers) PG Bug reporting form <noreply@postgresql.org> 2023-09-20 14:20 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox