| From: | Aleksander Alekseev <aleksander(at)timescale(dot)com> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, exclusion(at)gmail(dot)com |
| Subject: | Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error |
| Date: | 2024-07-15 12:17:53 |
| Message-ID: | CAJ7c6TN-yeXYS27DDd+eaOCRunjSCMNScHYJW-NarUQTC4Bh=Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
> > triggers an error:
> > ERROR: XX000: missing recursive reference
> > LOCATION: checkWellFormedRecursion, parse_cte.c:896
>
> FWIW I couldn't reproduce the reported error on REL_17_STABLE
> (b8bf76cbde39). The error I got seems reasonable:
>
> ```
> 46087 (master) =# WITH RECURSIVE t(n) AS (
> WITH t1 AS (SELECT 1 FROM t) SELECT 1
> UNION
> SELECT 1 FROM t1)
> SELECT * FROM t;
> ERROR: recursive reference to query "t" must not appear within a subquery
> LINE 2: WITH t1 AS (SELECT 1 FROM t) SELECT 1
> ^
> ```
>
> We should add regression tests though, as v2 does.
Oops. That's because Tom pushed this already (cf588e10f664). Sorry for
the noise.
--
Best regards,
Aleksander Alekseev
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tender Wang | 2024-07-15 13:18:34 | Re: BUG #18541: Reattaching a partition referenced by a foreign key fails with an error |
| Previous Message | Aleksander Alekseev | 2024-07-15 12:16:09 | Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error |