Postgres Pro
Downloads
Home   >   mailing lists

SELECT do not return all rows depending on selected columns - Mailing list pgsql-bugs

From Fabrice LEGROS
Subject SELECT do not return all rows depending on selected columns
Date
Msg-id DB6PR0301MB2552152ABBF61DAF79156B83938E0@DB6PR0301MB2552.eurprd03.prod.outlook.com
Whole thread Raw
Responses Re: SELECT do not return all rows depending on selected columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view

Hello,

 

In attachment, there is 2 files :

  • init.sql  to create and fill a table
  • request.sql with a select on this table

 

The request return 2122 rows, if I remove the second column (v2.journalcode) from the select I get 2801 rows (which is the expected result).

Tested on "PostgreSQL 9.6.10 on x86_64-pc-linux-gnu (Debian 9.6.10-1.pgdg90+1), compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit"

 

Also tested on "PostgreSQL 10.5 (Debian 10.5-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit"

Same behavior, but with 2133 rows for the select with 2 columns.

 

Regards,

Fabrice Legros.

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is temporary functions feature official/supported? Found some issues with it.
Next
From: Alvaro Herrera
Date:
Subject: Re: Is temporary functions feature official/supported? Found someissues with it.