BUG #16425: Possible error in full join - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16425: Possible error in full join
Date
Msg-id 16425-e3aada668f86fc39@postgresql.org
Whole thread Raw
Responses Re: BUG #16425: Possible error in full join
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16425
Logged by:          Michal C
Email address:      c_michal@poczta.onet.pl
PostgreSQL version: 12.2
Operating system:   Windows 10
Description:

Sorry for my English
My PG version: "PostgreSQL 12.2, compiled by Visual C++ build 1914,
64-bit"

Example for bag:  
with d (a,b) as (values (null::varchar(255),1))
select * 
from d d1
full join d d2 using (a,b);

Result:
"a"    "b"
null    1
null    1

Why select returns 2 records, Is this correct?


pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #16424: COPY Command fails for CSV formath
Next
From: Jeff Janes
Date:
Subject: Re: BUG #16425: Possible error in full join