BUG #17708: 12.4 - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17708: 12.4
Date
Msg-id 17708-1d976d155a1b2b41@postgresql.org
Whole thread Raw
Responses Re: BUG #17708: 12.4
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17708
Logged by:          zoro roronoa
Email address:      nodepill@gmail.com
PostgreSQL version: 15.1
Operating system:   macOS 12.4
Description:

PostgreSQL 14.6 on x86_64-apple-darwin20.6.0, comp


WITH RECURSIVE search_tree(id, link, data) AS (
                     SELECT t.id, t.link, t.data
                     FROM tree t
                     UNION ALL
                     SELECT t.id, t.link, t.data
                     FROM tree t join  search_tree st on  t.id = st.link
                     WHERE  t.id < 2
                 ) SEARCH DEPTH FIRST BY id SET ordercol


 [42601] ERROR: syntax error at end of input

But run ok in PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on
x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110,
64-bit


pgsql-bugs by date:

Previous
From: Justin Baur
Date:
Subject: Re: CREATE COLLATION without LOCALE throws error in v15
Next
From: PG Bug reporting form
Date:
Subject: BUG #17709: Regression in PG15 with window functions - "WindowFunc not found in subplan target lists"