FETCH FIRST clause WITH TIES option

Edit

ID 1844

Title FETCH FIRST clause WITH TIES option

Topic SQL Commands

Created 2018-10-26 10:44:53

Last modified 2020-04-07 22:48:14 (4 years, 7 months ago)

Latest email 2020-04-08 04:29:24 (4 years, 7 months ago)

Status

2020-03: Committed

2020-01: Moved to next CF

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

2019-03: Moved to next CF

2019-01: Moved to next CF

2018-11: Moved to next CF

Target version

Authors Surafel Temesgen (surafel)

Reviewers Tomas Vondra (fuzzycz), Vik Fearing (xocolatl)Become reviewer

Committer Álvaro Herrera (alvherre)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1844
git checkout commitfest/cf/1844

Emails

FETCH FIRST clause WITH TIES option: First at 2018-10-26 10:28:31 by Surafel Temesgen <surafel3000 at gmail.com>
Latest at 2020-04-08 04:29:24 by Andrew Gierth <andrew at tao11.riddles.org.uk>
Latest attachment (v16-0001-FETCH-FIRST-WITH-TIES.patch) at 2020-04-07 00:35:02 from Alvaro Herrera <alvherre at 2ndquadrant.com>
    Attachment (v16-0001-FETCH-FIRST-WITH-TIES.patch) at 2020-04-07 00:35:02 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch-first-with-ties-v15.patch) at 2020-01-22 06:19:46 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v14.patch) at 2019-11-28 13:37:12 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v13.patch) at 2019-11-27 09:11:13 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-v13.patch) at 2019-11-26 15:09:41 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (with_ties_gram.patch) at 2019-11-25 20:34:42 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v13-0001-limit-.-with-ties.patch) at 2019-11-11 14:56:49 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v12.patch) at 2019-09-10 10:37:57 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v11.patch) at 2019-07-03 10:40:18 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v10.patch) at 2019-07-01 17:38:24 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v9.patch) at 2019-04-06 22:39:26 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v8.patch) at 2019-04-01 06:57:41 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (0001-fetch_first_with_ties_v7.patch) at 2019-03-31 00:14:46 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v7.patch) at 2019-03-26 07:46:00 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v6.patch) at 2019-02-04 10:37:39 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v5.patch) at 2019-01-16 08:45:46 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v4.patch) at 2019-01-02 10:51:40 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (regression.diffs) at 2019-01-01 17:37:58 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v3.patch) at 2018-11-24 09:28:21 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v2.patch) at 2018-11-01 11:28:11 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (0002-review.patch) at 2018-10-28 18:20:35 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch_first_with_ties_v1.patch) at 2018-10-26 10:28:31 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
A rather hackish POC for alternative implementation of WITH TIES: First at 2019-11-29 05:39:57 by Andrew Gierth <andrew at tao11.riddles.org.uk>
Latest at 2020-03-31 15:24:42 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest attachment (with_ties_window.patch) at 2019-11-29 05:39:57 from Andrew Gierth <andrew at tao11.riddles.org.uk>
Attachment (with_ties_window.patch) at 2019-11-29 05:39:57 from Andrew Gierth <andrew at tao11.riddles.org.uk> (Patch: Yes)

History

When	Who	What
2020-04-07 22:48:14	Álvaro Herrera (alvherre)	Closed in commitfest 2020-03 with status: Committed
2020-04-07 22:48:14	Álvaro Herrera (alvherre)	Changed committer to alvherre
2020-02-01 12:58:14	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-30 15:40:44	Vik Fearing (xocolatl)	Added xocolatl as reviewer
2020-01-22 06:21:49	Surafel Temesgen (surafel)	New status: Needs review
2020-01-05 15:31:47	Tomas Vondra (fuzzycz)	Attached mail thread 87o8wvz253.fsf@news-spur.riddles.org.uk
2019-11-28 03:58:54	Michael Paquier (michael-kun)	New status: Waiting on Author
2019-11-28 03:58:47	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-28 03:58:44	Michael Paquier (michael-kun)	New status: Needs review
2019-11-26 15:31:24	Álvaro Herrera (alvherre)	New status: Waiting on Author
2019-09-30 19:14:35	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-10 10:45:09	Surafel Temesgen (surafel)	New status: Ready for Committer
2019-08-01 23:14:46	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-09 03:35:44	Michael Paquier (michael-kun)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-26 08:27:55	Surafel Temesgen (surafel)	New status: Needs review
2019-03-25 08:56:09	David Steele (dsteele)	New status: Waiting on Author
2019-02-05 08:05:28	Surafel Temesgen (surafel)	New status: Needs review
2019-02-04 05:29:07	Michael Paquier (michael-kun)	New status: Waiting on Author
2019-02-04 05:29:02	Michael Paquier (michael-kun)	Closed in commitfest 2019-01 with status: Moved to next CF
2019-01-17 12:47:40	Surafel Temesgen (surafel)	New status: Needs review
2019-01-01 17:40:59	Tomas Vondra (fuzzycz)	New status: Waiting on Author
2018-12-01 12:01:13	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-25 10:13:47	Surafel Temesgen (surafel)	New status: Needs review
2018-10-28 18:21:00	Tomas Vondra (fuzzycz)	Added fuzzycz as reviewer
2018-10-28 18:20:57	Tomas Vondra (fuzzycz)	New status: Waiting on Author
2018-10-26 10:45:13	Surafel Temesgen (surafel)	Changed authors to Surafel Temesgen (surafel)
2018-10-26 10:44:54	Surafel Temesgen (surafel)	Attached mail thread CALAY4q9ky7rD_A4vf=FVQvCGngm3LOes-ky0J6euMrg=_Se+ag@mail.gmail.com
2018-10-26 10:44:53	Surafel Temesgen (surafel)	Created patch record

Edit