Re: Modify an incorrect regression test case in the group by key value elimination function - Mailing list pgsql-hackers

From David Rowley
Subject Re: Modify an incorrect regression test case in the group by key value elimination function
Date
Msg-id CAApHDvrV9ferzYvvWVVwLmDgUEeTLVjd4E1Wrwksm2BD9eQGgw@mail.gmail.com
Whole thread Raw
List pgsql-hackers
On Tue, 18 Feb 2025 at 20:40, songjinzhou <tsinghualucky912@foxmail.com> wrote:
> Two months ago, we enhanced the group by key value elimination function. This is a very useful function. When I was
learning,I found a regression test case that was not suitable, as follows:
 

> Because the table structure of t3 is defined as follows(Its PK is deferrable):

> I think this test case does not fully reflect the original meaning. So I made a small change to this and look forward
toyour feedback. Thanks!
 

That's my mistake. Thanks for spotting it.

I looked at your patch and felt that the flow would be better if all
those tests used t2 rather than t3.  That way we don't need to add the
NOT NULL constraint to both tables, just t2. I wrote the patch to do
it that way and pushed it.

David



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Add an option to skip loading missing publication to avoid logical replication failure
Next
From: Andy Fan
Date:
Subject: Why does exec_simple_query requires 2 snapshots