From: Tom Lane <tgl@sss.pgh.pa.us>
To: cute_hoay88@hotmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17818: CTE is not returning the right data.
Date: Thu, 02 Mar 2023 10:41:17 -0500
Message-ID: <1905386.1677771677@sss.pgh.pa.us> (raw)
In-Reply-To: <17818-2ef0f7567df79f09@postgresql.org>
References: <17818-2ef0f7567df79f09@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> PostgreSQL version: 12.1
> Scenario: When i execute this above query, i am not able to find the feature
> AA and Item AA EXT Inner-Lane- 1.1G.
> But weird is i tried out with this (below example: Add WHERE inside the
> cte), then i am able to get the item:
I agree that's strange, but ...
> Can you please help to investigate and explain what is the possible root
> cause for this?
Nobody is going to be able to help you from that amount of information.
I would suggest, if you really are running 12.1, that your first step
should be to update to 12.latest (currently 12.14), as you are missing
more than three years worth of bug fixes. Another useful step could be
to re-index these tables, just in case the problem is index corruption.
(Do that *after* updating.)
If you still see strange behavior, and can provide a self-contained test
case, we'd be happy to look at it.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, cute_hoay88@hotmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17818: CTE is not returning the right data.
In-Reply-To: <1905386.1677771677@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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