*** /home/user/work/postgres/src/test/regress/expected/limit.out 2019-01-01 18:04:32.863729423 +0100 --- /home/user/work/postgres/src/test/regress/results/limit.out 2019-01-01 18:14:13.328729423 +0100 *************** *** 512,527 **** ORDER BY thousand FETCH FIRST 2 ROW WITH TIES; two | unique1 | unique2 | stringu1 | thousand -----+---------+---------+----------+---------- - | 800 | 9 | UEAAAA | 0 | 200 | 95 | SHAAAA | 0 - | 500 | 262 | GTAAAA | 0 - | 400 | 309 | KPAAAA | 0 - | 300 | 374 | OLAAAA | 0 - | 600 | 402 | CXAAAA | 0 | 700 | 434 | YAAAAA | 0 | 900 | 913 | QIAAAA | 0 - | 100 | 946 | WDAAAA | 0 | 0 | 998 | AAAAAA | 0 (10 rows) SELECT ''::text AS two, unique1, unique2, stringu1, thousand --- 512,527 ---- ORDER BY thousand FETCH FIRST 2 ROW WITH TIES; two | unique1 | unique2 | stringu1 | thousand -----+---------+---------+----------+---------- | 200 | 95 | SHAAAA | 0 | 700 | 434 | YAAAAA | 0 + | 600 | 402 | CXAAAA | 0 | 900 | 913 | QIAAAA | 0 | 0 | 998 | AAAAAA | 0 + | 500 | 262 | GTAAAA | 0 + | 800 | 9 | UEAAAA | 0 + | 100 | 946 | WDAAAA | 0 + | 400 | 309 | KPAAAA | 0 + | 300 | 374 | OLAAAA | 0 (10 rows) SELECT ''::text AS two, unique1, unique2, stringu1, thousand *************** *** 529,536 **** ORDER BY thousand FETCH FIRST 2 ROW ONLY; two | unique1 | unique2 | stringu1 | thousand -----+---------+---------+----------+---------- | 200 | 95 | SHAAAA | 0 - | 500 | 262 | GTAAAA | 0 (2 rows) -- should fail --- 529,536 ---- ORDER BY thousand FETCH FIRST 2 ROW ONLY; two | unique1 | unique2 | stringu1 | thousand -----+---------+---------+----------+---------- + | 800 | 9 | UEAAAA | 0 | 200 | 95 | SHAAAA | 0 (2 rows) -- should fail ======================================================================