PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16083
PG Version9.6.15
OSLinux & Windows
Opened2019-10-28 07:15:16+00
Reported byEka Setiawan Saputra
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16083
Logged by:          Eka Setiawan Saputra
Email address:      (redacted)
PostgreSQL version: 9.6.15
Operating system:   Linux & Windows
Description:        

This query is show different result ordering on windows and linux

SELECT * FROM (
	SELECT '{A}' AS Y UNION
    SELECT '{A, AA}' AS Y UNION
    SELECT '{A, AA, AAA}' AS Y
) X
ORDER BY Y ASC

Messages

DateAuthorSubject
2019-10-28 07:15:16+00PG Bug reporting formBUG #16083: Different Result
2019-10-28 07:35:35+00Pavel StehuleRe: BUG #16083: Different Result