FETCH FIRST clause PERCENT option

Edit
Comment/Review
Change Status
ID 2176
Title FETCH FIRST clause PERCENT option
Topic SQL Commands
Created 2019-06-27 10:21:45
Last modified 2021-10-03 16:16:24 (3 years, 1 month ago)
Latest email 2021-09-30 18:31:16 (3 years, 1 month ago)
Status
2021-09: Returned with feedback
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
Target version
Authors Surafel Temesgen (surafel)
Reviewers Become reviewer
Committer
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/2176
git checkout commitfest/cf/2176
Emails
FETCH FIRST clause PERCENT option
First at 2018-08-16 14:27:45 by Surafel Temesgen <surafel3000 at gmail.com>
Latest at 2021-09-30 18:31:16 by Jaime Casanova <jcasanov at systemguards.com.ec>
Latest attachment (gdb_fetch_percent.txt) at 2021-01-26 09:19:19 from Jaime Casanova <jcasanov at systemguards.com.ec>
    Attachment (gdb_fetch_percent.txt) at 2021-01-26 09:19:19 from Jaime Casanova <jcasanov at systemguards.com.ec> (Patch: No)
    Attachment (percent-incremental-v11.patch) at 2020-09-25 09:25:24 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v10.patch) at 2020-08-10 10:23:44 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v9.patch) at 2019-09-19 12:52:32 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v8.patch) at 2019-08-22 07:40:30 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v7.patch) at 2019-08-19 09:18:39 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v6-comment-cleanup.patch) at 2019-08-06 22:52:12 from Ryan Lambert <ryan at rustprooflabs.com> (Patch: Yes)
    Attachment (percent-incremental-v6.patch) at 2019-08-01 12:54:11 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v5.patch) at 2019-07-08 07:08:36 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v4.patch) at 2019-06-27 09:06:05 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v3.patch) at 2019-03-29 09:04:50 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-with-percent-v9.patch) at 2019-03-01 12:47:43 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v2.patch) at 2019-02-28 10:32:17 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-with-percent-v8.patch) at 2019-02-01 11:10:38 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental-v2.patch) at 2019-01-24 09:57:08 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (percent-incremental.patch) at 2019-01-09 17:18:06 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (fetch-with-percent-inprogress.patch) at 2019-01-09 15:43:54 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v7.patch) at 2018-11-30 10:22:07 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v6.patch) at 2018-11-30 07:23:42 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v5.patch) at 2018-11-25 09:00:43 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v4.patch) at 2018-09-25 12:07:17 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v3.patch) at 2018-08-31 11:42:05 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v2.patch) at 2018-08-28 12:14:43 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)
    Attachment (fetch-wth-percent-v1.patch) at 2018-08-16 14:27:45 from Surafel Temesgen <surafel3000 at gmail.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2019-06-28 05:33:51 Surafel Temesgen (surafel) From Surafel Temesgen <surafel3000@gmail.com>
at 2019-06-27 09:06:05		 Re: FETCH FIRST clause PERCENT option
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
2021-10-03 16:16:24 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Returned with feedback
2021-09-29 16:58:13 Jaime Casanova (jcasanov) New status: Waiting on Author
2021-08-03 02:31:27 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-04-08 15:49:26 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-01 12:48:17 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-10 23:24:50 Ryan Lambert (ryanlambert) Removed ryanlambert from reviewers
2020-12-01 09:51:19 Georgios Kokolatos (gkokolatos) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-01 04:45:47 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-25 09:51:22 Surafel Temesgen (surafel) New status: Needs review
2020-09-24 03:57:36 Michael Paquier (michael-kun) New status: Waiting on Author
2020-08-03 20:50:11 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-07-06 15:26:01 Álvaro Herrera (alvherre) Removed alvherre from committers
2020-07-06 15:25:55 Álvaro Herrera (alvherre) New status: Needs review
2020-07-01 11:29:02 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Committed
2020-07-01 11:29:02 Daniel Gustafsson (d_gustafsson) Changed committer to alvherre
2020-04-08 15:41:08 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:58:29 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-16 21:34:05 Tomas Vondra (fuzzycz) New status: Needs review
2020-01-05 15:31:16 Tomas Vondra (fuzzycz) Attached mail thread 87o8wvz253.fsf@news-spur.riddles.org.uk
2019-11-29 06:15:55 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 19:07:48 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-30 16:47:04 Ryan Lambert (ryanlambert) Posted review with messageid <156986202411.13914.3495086274423910386.pgcf@coridan.postgresql.org>
2019-09-30 16:47:04 Ryan Lambert (ryanlambert) New status: Ready for Committer
2019-09-18 15:09:31 Álvaro Herrera (alvherre) New status: Needs review
2019-09-05 23:26:17 Álvaro Herrera (alvherre) New status: Waiting on Author
2019-08-28 21:56:54 Ryan Lambert (ryanlambert) Posted review with messageid <156702941415.1187.16917229895564746124.pgcf@coridan.postgresql.org>
2019-08-28 21:56:54 Ryan Lambert (ryanlambert) New status: Ready for Committer
2019-08-23 02:03:35 Ryan Lambert (ryanlambert) New status: Needs review
2019-08-18 23:33:51 Ryan Lambert (ryanlambert) Posted review with messageid <156617123172.1495.14662132810242384888.pgcf@coridan.postgresql.org>
2019-08-18 23:33:51 Ryan Lambert (ryanlambert) New status: Ready for Committer
2019-08-06 05:35:28 Surafel Temesgen (surafel) New status: Needs review
2019-08-01 11:24:28 Thomas Munro (macdice) New status: Waiting on Author
2019-08-01 11:24:17 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-08-01 11:24:13 Thomas Munro (macdice) New status: Needs review
2019-07-11 01:57:21 Ryan Lambert (ryanlambert) New status: Waiting on Author
2019-07-08 10:20:50 Surafel Temesgen (surafel) New status: Needs review
2019-07-08 02:35:29 Ryan Lambert (ryanlambert) Posted review with messageid <156255332925.1365.9370118521787584249.pgcf@coridan.postgresql.org>
2019-07-08 02:35:29 Ryan Lambert (ryanlambert) New status: Waiting on Author
2019-07-08 02:11:46 Ryan Lambert (ryanlambert) Added ryanlambert as reviewer
2019-06-28 05:33:51 Surafel Temesgen (surafel) Added annotation "Re: FETCH FIRST clause PERCENT option" to CALAY4q-eqSwkv3riFM_HF7THWBr9DuTJqZDkCYBmhF7vNdpqvw@mail.gmail.com
2019-06-27 10:25:25 Surafel Temesgen (surafel) Changed authors to Surafel Temesgen (surafel)
2019-06-27 10:21:45 Surafel Temesgen (surafel) Attached mail thread CALAY4q9Esidbuz4fvUrGA-uOHNwbEsntLZQ8p=_okDvaTzJ3pA@mail.gmail.com
2019-06-27 10:21:45 Surafel Temesgen (surafel) Created patch record
Edit
Comment/Review
Change Status