pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17708: 12.4
2+ messages / 2 participants
[nested] [flat]
* BUG #17708: 12.4
@ 2022-12-09 05:33 PG Bug reporting form <noreply@postgresql.org>
2022-12-09 14:34 ` Re: BUG #17708: 12.4 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2022-12-09 05:33 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: nodepill@gmail.com
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17708: 12.4
2022-12-09 05:33 BUG #17708: 12.4 PG Bug reporting form <noreply@postgresql.org>
@ 2022-12-09 14:34 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2022-12-09 14:34 UTC (permalink / raw)
To: nodepill@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> 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
Yeah ... you wrote a WITH clause, but where's the main SELECT?
> But run ok in PostgreSQL 15.1
I *seriously* doubt that.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-12-09 14:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-09 05:33 BUG #17708: 12.4 PG Bug reporting form <noreply@postgresql.org>
2022-12-09 14:34 ` 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