Enterprise Postgres 17 リリース情報

2.3.39 名前が競合する場合のビュー定義の表示の変更

非互換

Fujitsu Enterprise Postgres 17では、名前が競合する場合にもビュー定義を正しく表示するように変更します。

Fujitsu Enterprise Postgres 16 SP1の場合

postgres=# create view aliased_order_by as
postgres-# select x1 as x2, x2 as x1, x3 from tt1
postgres-#   order by x2;  -- this is interpreted per SQL92, so really ordering by x1
CREATE VIEW
postgres=# \d+ aliased_order_by
                   View "testviewschm2.aliased_order_by"
 Column |  Type   | Collation | Nullable | Default | Storage  | Description
--------+---------+-----------+----------+---------+----------+-------------
 x2     | integer |           |          |         | plain    |
 x1     | integer |           |          |         | plain    |
 x3     | text    |           |          |         | extended |
View definition:
 SELECT x1 AS x2,
    x2 AS x1,
    x3
   FROM tt1
  ORDER BY x1;

Fujitsu Enterprise Postgres 17の場合

postgres=# \d+ aliased_order_by
                   View "testviewschm2.aliased_order_by"
 Column |  Type   | Collation | Nullable | Default | Storage  | Description
--------+---------+-----------+----------+---------+----------+-------------
 x2     | integer |           |          |         | plain    |
 x1     | integer |           |          |         | plain    |
 x3     | text    |           |          |         | extended |
View definition:
 SELECT x1 AS x2,
    x2 AS x1,
    x3
   FROM tt1
  ORDER BY tt1.x1;

対処方法

ありません。