BUG #18929: After the view is created, executed query against the view definition, reported syntax error.
От | PG Bug reporting form |
---|---|
Тема | BUG #18929: After the view is created, executed query against the view definition, reported syntax error. |
Дата | |
Msg-id | 18929-077d6b7093b176e2@postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 18929 Logged by: yonghao lee Email address: 707330139@qq.com PostgreSQL version: 17.5 Operating system: linux Description: Hello PostgreSQL team, I found an error in the view definition SQL given when looking at the view description using \d+. Here are the detailed steps for this problem. executed query: postgres=# CREATE TABLE onek (thousand int4); CREATE TABLE postgres=# CREATE VIEW limit_thousand_v_3 AS SELECT thousand FROM onek WHERE thousand < 995 ORDER BY thousand FETCH FIRST (NULL::bigint + 1::bigint) ROWS WITH TIES; CREATE VIEW postgres=# \d+ limit_thousand_v_3 View "public.limit_thousand_v_3" Column | Type | Collation | Nullable | Default | Storage | Description ----------+---------+-----------+----------+---------+---------+------------- thousand | integer | | | | plain | View definition: SELECT thousand FROM onek WHERE thousand < 995 ORDER BY thousand FETCH FIRST NULL::bigint + 1::bigint ROWS WITH TIES; postgres=# SELECT thousand postgres-# FROM onek postgres-# WHERE thousand < 995 postgres-# ORDER BY thousand postgres-# FETCH FIRST NULL::bigint + 1::bigint ROWS WITH TIES; ERROR: syntax error at or near "::" LINE 5: FETCH FIRST NULL::bigint + 1::bigint ROWS WITH TIES; ^ I think that executing the view definition query will be successful. I'm happy to provide more info if I can/ if needed. Thanks, yonghao lee, Highgo software.
В списке pgsql-bugs по дате отправления: