public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Rowley <[email protected]>
To: Rumpi Gravenstein <[email protected]>
Cc: PostgreSQL <[email protected]>
Subject: Re: Analytic Function Bug
Date: Fri, 30 Aug 2024 13:24:17 +1200
Message-ID: <CAApHDvr0par1jqFJQPbewoqjuFUNQQXs5X+dPVQDxcwkvW_mvA@mail.gmail.com> (raw)
In-Reply-To: <CAEpg1wDJU6DzUJxJdFAUZFzmw6bY+p17bXvCLupwsxc0V6vqrg@mail.gmail.com>
References: <CAEpg1wDJU6DzUJxJdFAUZFzmw6bY+p17bXvCLupwsxc0V6vqrg@mail.gmail.com>

On Fri, 30 Aug 2024 at 11:18, Rumpi Gravenstein <[email protected]> wrote:

>
> Which returns:
> logical_partition_keyusage_texttxtrpo_txtindxmx_indxprvnxtnxt2prv2prv3
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" "F" "1" "7" *"F"* "(" "(" "[NULL]"
> "[NULL]"
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" "(" "2" "7" "F" "(" "T61" "F" "[NULL]"
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" "T61" "3" "7" *"T61"* ")" ")" "(" "("
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" ")" "4" "7" "T61" ")" "(" "T61" "("
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" "(" "5" "7" "*("* "EXPORT" "EXPORT" ")"
> ")"
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" "EXPORT" "6" "7" "(" "EXPORT" ")" "("
> ")"
> "TEST_DATA"
> "F(T61)(EXPORT)" "F(T61)(EXPORT)" ")" "7" "7" ")" "[NULL]" "[NULL]"
> "EXPORT" "EXPORT"
> Notice that the prv column (lag - 1 ) is just wrong.  I've highlighted
> obvious bad values.  Other columns are wrong as well.
>
> Is this a PostgreSQL bug?
>

FWIW, these aren't the results I see when executing your query on 14.13.
I'm not sure what interface you're using to get those tables, but let's
eliminate some buggy GUI and use psql instead.

I've attached a script, could you send us back the output of it with
something like?: psql -f lag_query.sql > lagscript.txt

I've included a query to give us the EXPLAIN ANALYZE output too. The WHERE
clause quals shouldn't get pushed down since the PARTITION BY clause does
not contain all of those fields.

David


Attachments:

  [application/octet-stream] lag_query.sql (3.3K, 3-lag_query.sql)
  download

view thread (7+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Analytic Function Bug
  In-Reply-To: <CAApHDvr0par1jqFJQPbewoqjuFUNQQXs5X+dPVQDxcwkvW_mvA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox