ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)
3 patchsets tracked - current t253274_7
v7t253274_7posted Oct 17, 09:20successappliesrecent 0dpg 20
base892cfb4cb 1 day ago on master
applyapplied about 24 hours ago
rebaselast tried about 24 hours ago on 892cfb4cb
pushabout 24 hours ago -> 498286071branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1070 / 1070 | 2m 00s / 4m 38s | docker run ... :t253274 | about 24 hours ago |
run 44919944508executed 1070 - ccache 78 hit / 6547 miss - head 498286071 - digest sha256:3e884612dc649b... - run 44919944508 | ||||||
| success | 1 | 20 | 1069 / 1069 | 2m 21s / 4m 53s | docker run ... @sha256:512b654... | 2 days ago |
run 44764542957executed 1069 - ccache 78 hit / 6547 miss - head 25a5acf07 - digest sha256:512b654174ff77... - run 44764542957 | ||||||
| success | 1 | 20 | 1068 / 1068 | 1m 59s / 4m 07s | docker run ... @sha256:270fe84... | 3 days ago |
run 44555637210executed 1068 - ccache 78 hit / 6547 miss - head a69e7d1b5 - digest sha256:270fe8410f0cd7... - run 44555637210 | ||||||
| success | 1 | 20 | 1067 / 1067 | 3m 09s / 5m 51s | docker run ... @sha256:735a7c6... | 4 days ago |
run 44336339090executed 1067 - ccache 78 hit / 6547 miss - head 623f70ac4 - digest sha256:735a7c6039bf23... - run 44336339090 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 21s / 4m 43s | docker run ... @sha256:ad24c59... | 5 days ago |
run 44111548912executed 1067 - ccache 78 hit / 6547 miss - head fbaf8e7a8 - digest sha256:ad24c59c0f0337... - run 44111548912 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 21s / 4m 50s | docker run ... @sha256:ce331fa... | 6 days ago |
run 43893111406executed 1067 - ccache 78 hit / 6547 miss - head 4bf80d4c3 - digest sha256:ce331fa3cefe7f... - run 43893111406 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 18s / 4m 48s | docker run ... @sha256:9ee8bf6... | Nov 15, 10:55 |
run 43705653056executed 1067 - ccache 78 hit / 6547 miss - head 095260bcc - digest sha256:9ee8bf6d150f41... - run 43705653056 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 20s / 4m 57s | docker run ... @sha256:4c787b4... | Nov 14, 10:54 |
run 43586754079executed 1067 - ccache 78 hit / 6547 miss - head ebe092aec - digest sha256:4c787b4f45fcd6... - run 43586754079 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 16s / 4m 30s | docker run ... @sha256:b5e13f4... | Nov 13, 10:51 |
run 43411205444executed 1067 - ccache 78 hit / 6547 miss - head e49809b1b - digest sha256:b5e13f471554fc... - run 43411205444 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 20s / 4m 59s | docker run ... @sha256:e946536... | Nov 12, 10:50 |
run 43202454584executed 1067 - ccache 78 hit / 6547 miss - head b16185aa1 - digest sha256:e946536c9a13c5... - run 43202454584 | ||||||
| success | 1 | 20 | 1067 / 1067 | 3m 04s / 5m 44s | docker run ... @sha256:46aa97b... | Nov 11, 10:48 |
run 43005217180executed 1067 - ccache 78 hit / 6547 miss - head d9de08aa5 - digest sha256:46aa97b559819b... - run 43005217180 | ||||||
| success | 1 | 20 | 1067 / 1067 | 2m 55s / 5m 30s | docker run ... @sha256:8591ee8... | Nov 10, 10:47 |
run 42800592648executed 1067 - ccache 78 hit / 6547 miss - head 5b56ac8ca - digest sha256:8591ee8d9d8966... - run 42800592648 | ||||||
| success | 1 | 20 | 1053 / 1053 | 1m 51s / 4m 21s | docker run ... @sha256:e05ca98... | Nov 09, 10:44 |
run 42601958455executed 1053 - ccache 78 hit / 6546 miss - head ab4744431 - digest sha256:e05ca98043f13a... - run 42601958455 | ||||||
| success | 1 | 20 | 1053 / 1053 | 2m 18s / 4m 54s | docker run ... @sha256:9a9af47... | Nov 06, 10:41 |
run 42203338325executed 1053 - ccache 78 hit / 6546 miss - head 609c0f22a - digest sha256:9a9af47da683bd... - run 42203338325 | ||||||
| success | 1 | 20 | 1053 / 1053 | 3m 03s / 5m 39s | docker run ... @sha256:58c34d4... | Nov 05, 10:38 |
run 42010844959executed 1053 - ccache 78 hit / 6546 miss - head 873626e1d - digest sha256:58c34d4c50c355... - run 42010844959 | ||||||
| success | 1 | 20 | 1052 / 1052 | 3m 04s / 5m 23s | docker run ... @sha256:7820828... | Nov 03, 10:32 |
run 41618527384executed 1052 - ccache 78 hit / 6544 miss - head a63e4730b - digest sha256:782082804d5b8b... - run 41618527384 | ||||||
| success | 1 | 20 | 1052 / 1052 | 3m 06s / 5m 27s | docker run ... @sha256:948a44e... | Nov 02, 10:28 |
run 41427535804executed 1052 - ccache 78 hit / 6544 miss - head 091a344b5 - digest sha256:948a44ed9d699e... - run 41427535804 | ||||||
| success | 1 | 20 | 1051 / 1051 | 2m 17s / 4m 47s | docker run ... @sha256:80cbbc2... | Nov 01, 10:21 |
run 41296458884executed 1051 - ccache 78 hit / 6544 miss - head ab9a38fe3 - digest sha256:80cbbc2eb7c41b... - run 41296458884 | ||||||
| success | 1 | 20 | 1051 / 1051 | 2m 30s / 4m 33s | docker run ... @sha256:3f5e3b0... | Oct 31, 10:19 |
run 41191649537executed 1051 - ccache 78 hit / 6544 miss - head 9d49049e0 - digest sha256:3f5e3b08423f71... - run 41191649537 | ||||||
| success | 1 | 20 | 1051 / 1051 | 2m 53s / 4m 57s | docker run ... @sha256:ffa9b93... | Oct 30, 10:18 |
run 41038500549executed 1051 - ccache 78 hit / 6544 miss - head 624027802 - digest sha256:ffa9b93305e9e2... - run 41038500549 | ||||||
| success | 1 | 20 | 1051 / 1051 | 1m 48s / 4m 26s | docker run ... @sha256:dab6e67... | Oct 29, 10:15 |
run 40854893085executed 1051 - ccache 78 hit / 6544 miss - head b10387a2c - digest sha256:dab6e670b5d68b... - run 40854893085 | ||||||
| success | 1 | 20 | 1051 / 1051 | 2m 57s / 5m 18s | docker run ... @sha256:d3b97a2... | Oct 28, 10:15 |
run 40669271799executed 1051 - ccache 78 hit / 6544 miss - head 98adeb14a - digest sha256:d3b97a2313b845... - run 40669271799 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 56s / 5m 45s | docker run ... @sha256:e118c6b... | Oct 27, 10:13 |
run 40485337710executed 1050 - ccache 78 hit / 6544 miss - head 411a7e6d5 - digest sha256:e118c6b7114496... - run 40485337710 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 09s / 4m 48s | docker run ... @sha256:eb88402... | Oct 26, 10:09 |
run 40303849259executed 1050 - ccache 78 hit / 6544 miss - head 1c999ab08 - digest sha256:eb8840273c6e16... - run 40303849259 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 58s / 5m 36s | docker run ... @sha256:9c0acc2... | Oct 25, 10:08 |
run 40182757822executed 1050 - ccache 78 hit / 6544 miss - head fa8a24ed0 - digest sha256:9c0acc20402635... - run 40182757822 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 47s / 5m 09s | docker run ... @sha256:b19bcb6... | Oct 24, 10:05 |
run 40083860738executed 1050 - ccache 78 hit / 6544 miss - head 35bfd59b2 - digest sha256:b19bcb687377e3... - run 40083860738 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 39s / 4m 51s | docker run ... @sha256:ec38d55... | Oct 23, 10:02 |
run 39934987055executed 1050 - ccache 78 hit / 6544 miss - head 4b5d69bfc - digest sha256:ec38d55c3959d6... - run 39934987055 | ||||||
| success | 1 | 20 | 1050 / 1050 | 3m 07s / 5m 42s | docker run ... @sha256:3dc9414... | Oct 22, 09:54 |
run 39757619308executed 1050 - ccache 78 hit / 6544 miss - head 1daa45d20 - digest sha256:3dc94148483b5d... - run 39757619308 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 51s / 5m 34s | docker run ... @sha256:530df5d... | Oct 21, 09:52 |
run 39578870966executed 1049 - ccache 78 hit / 6544 miss - head 97acae01f - digest sha256:530df5d797ea0d... - run 39578870966 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 52s / 5m 19s | docker run ... @sha256:857228b... | Oct 20, 09:40 |
run 39401019157executed 1049 - ccache 78 hit / 6544 miss - head b2a757e2e - digest sha256:857228b66b2edf... - run 39401019157 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 58s / 5m 26s | docker run ... @sha256:6274d04... | Oct 19, 09:37 |
run 39230153529executed 1049 - ccache 78 hit / 6544 miss - head 0803296c5 - digest sha256:6274d0414939a3... - run 39230153529 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 54s / 5m 35s | docker run ... @sha256:ab7f89e... | Oct 18, 09:35 |
run 39115203935executed 1049 - ccache 78 hit / 6544 miss - head 05fcb9f08 - digest sha256:ab7f89ed3efd5b... - run 39115203935 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 12s / 4m 27s | docker run ... @sha256:85637b6... | Oct 17, 09:31 |
run 39020861107executed 1049 - ccache 78 hit / 6544 miss - head 8099a8a49 - digest sha256:85637b64fba484... - run 39020861107 | ||||||
v3t253274_3posted Sep 16, 20:40successsupersededstale 36dpg 20
base57926d757 Oct 16, 08:06 on master
applyapplied Oct 16, 09:19
rebaselast tried Oct 16, 09:19 on 57926d757
pushOct 16, 09:19 -> cd499cb6cbranchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1049 / 1049 | 1m 55s / 4m 08s | docker run ... @sha256:82be1f5... | Oct 16, 09:28 |
run 38879712221executed 1049 - ccache 78 hit / 6544 miss - head cd499cb6c - digest sha256:82be1f54ab7d63... - run 38879712221 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 45s / 5m 19s | docker run ... @sha256:8862a17... | Oct 15, 09:27 |
run 38711855346executed 1049 - ccache 78 hit / 6544 miss - head 9edafa915 - digest sha256:8862a17b98867e... - run 38711855346 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 17s / 4m 49s | docker run ... @sha256:ee0c030... | Oct 14, 09:23 |
run 38540850893executed 1044 - ccache 78 hit / 6544 miss - head 925cf55af - digest sha256:ee0c0307b58f23... - run 38540850893 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 44s / 4m 52s | docker run ... @sha256:9e8bae8... | Oct 13, 09:20 |
run 38374336155executed 1044 - ccache 78 hit / 6544 miss - head 8bccbd9cc - digest sha256:9e8bae8a990689... - run 38374336155 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 55s / 5m 04s | docker run ... @sha256:f9ed3a8... | Oct 12, 09:16 |
run 38227650954executed 1044 - ccache 78 hit / 6544 miss - head bf9a99943 - digest sha256:f9ed3a8954904a... - run 38227650954 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 10s / 4m 48s | docker run ... @sha256:3ebf1d9... | Oct 11, 03:17 |
run 38107384678executed 1044 - ccache 78 hit / 6544 miss - head 3e0ee1af9 - digest sha256:3ebf1d9eb8ff70... - run 38107384678 | ||||||
| success | 1 | 20 | 1042 / 1042 | 2m 52s / 5m 28s | docker run ... @sha256:86623ea... | Oct 08, 03:15 |
run 37720945158executed 1042 - ccache 78 hit / 6544 miss - head dffa6523f - digest sha256:86623eafc70c91... - run 37720945158 | ||||||
| success | 1 | 20 | 1041 / 1041 | 2m 32s / 4m 32s | docker run ... @sha256:369bc84... | Oct 07, 03:12 |
run 37564876303executed 1041 - ccache 78 hit / 6544 miss - head 873946e9f - digest sha256:369bc84fc2bb13... - run 37564876303 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 47s / 5m 06s | docker run ... @sha256:8b5a2f9... | Oct 06, 03:11 |
run 37406950142executed 1039 - ccache 78 hit / 6544 miss - head 070e5fcb8 - digest sha256:8b5a2f9d304427... - run 37406950142 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 15s / 4m 43s | docker run ... @sha256:61ccddb... | Oct 05, 03:09 |
run 37257610959executed 1039 - ccache 78 hit / 6544 miss - head 077c3f5b2 - digest sha256:61ccddbb0603b9... - run 37257610959 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 49s / 4m 52s | docker run ... @sha256:14f481b... | Oct 04, 03:09 |
run 37172708625executed 1039 - ccache 78 hit / 6544 miss - head 7b8c41377 - digest sha256:14f481ba57bb96... - run 37172708625 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 52s / 5m 13s | docker run ... @sha256:cfc3be4... | Oct 03, 03:08 |
run 37091606461executed 1039 - ccache 78 hit / 6544 miss - head 237124257 - digest sha256:cfc3be45edd162... - run 37091606461 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 44s / 4m 20s | docker run ... @sha256:629238d... | Oct 02, 03:05 |
run 36957983383executed 1039 - ccache 78 hit / 6544 miss - head 08087b523 - digest sha256:629238dfad49e8... - run 36957983383 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 50s / 5m 19s | docker run ... @sha256:71c2de6... | Oct 01, 03:01 |
run 36807752045executed 1039 - ccache 78 hit / 6544 miss - head 8ae3dad20 - digest sha256:71c2de6536fdf9... - run 36807752045 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 57s / 5m 36s | docker run ... @sha256:bf2d89e... | Sep 30, 03:00 |
run 36661600830executed 1039 - ccache 78 hit / 6544 miss - head c0dd2e517 - digest sha256:bf2d89e98fb6e6... - run 36661600830 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 12s / 4m 45s | docker run ... @sha256:a943dd1... | Sep 29, 02:57 |
run 36514333431executed 1039 - ccache 78 hit / 6544 miss - head c3677930c - digest sha256:a943dd1c043d93... - run 36514333431 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 56s / 5m 30s | docker run ... @sha256:7d6b136... | Sep 28, 02:57 |
run 36371136457executed 1039 - ccache 78 hit / 6544 miss - head 08dac01df - digest sha256:7d6b136203b6f1... - run 36371136457 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 44s / 4m 41s | docker run ... @sha256:f61918c... | Sep 26, 22:10 |
run 36274830140executed 1039 - ccache 78 hit / 6544 miss - head 5a2594847 - digest sha256:f61918c75e68e9... - run 36274830140 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 55s / 5m 21s | docker run ... @sha256:1347b22... | Sep 25, 22:09 |
run 36194376544executed 1039 - ccache 78 hit / 6544 miss - head efc081bdd - digest sha256:1347b22e3d3f2d... - run 36194376544 | ||||||
| success | 1 | 20 | 1038 / 1038 | 2m 46s / 5m 20s | docker run ... @sha256:3605049... | Sep 24, 22:07 |
run 36064635423executed 1038 - ccache 78 hit / 6544 miss - head 6cb4758a4 - digest sha256:36050499f4350f... - run 36064635423 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 40s / 4m 35s | docker run ... @sha256:171c602... | Sep 23, 22:05 |
run 35925432525executed 1036 - ccache 98 hit / 6524 miss - head 116a02d09 - digest sha256:171c602e1f1ada... - run 35925432525 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 55s / 5m 35s | docker run ... @sha256:346bdd8... | Sep 22, 22:04 |
run 35789271674executed 1036 - ccache 98 hit / 6524 miss - head 8c80a41f9 - digest sha256:346bdd8b98cbbf... - run 35789271674 | ||||||
| success | 1 | 20 | 1036 / 1036 | 1m 54s / 4m 18s | docker run ... @sha256:9f87156... | Sep 21, 21:50 |
run 35658652090executed 1036 - ccache 98 hit / 6524 miss - head cb665cf7d - digest sha256:9f87156474cbb1... - run 35658652090 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 38s / 4m 34s | docker run ... @sha256:0ed81da... | Sep 20, 20:55 |
run 35536555679executed 1036 - ccache 98 hit / 6524 miss - head de5371614 - digest sha256:0ed81da8aa6642... - run 35536555679 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 09s / 4m 42s | docker run ... @sha256:ea40911... | Sep 19, 20:53 |
run 35468322900executed 1036 - ccache 98 hit / 6524 miss - head deeb2497c - digest sha256:ea40911a05c20b... - run 35468322900 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 10s / 4m 23s | docker run ... @sha256:b53d184... | Sep 18, 20:52 |
run 35392998110executed 1036 - ccache 98 hit / 6524 miss - head 0cc925b19 - digest sha256:b53d1849152047... - run 35392998110 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 57s / 5m 23s | docker run ... @sha256:53afe11... | Sep 17, 20:53 |
run 35272472858executed 1036 - ccache 98 hit / 6524 miss - head 7bf0e7225 - digest sha256:53afe11fb31faa... - run 35272472858 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 44s / 5m 27s | docker run ... @sha256:eff9d49... | Sep 16, 20:53 |
run 35148205776executed 1036 - ccache 98 hit / 6524 miss - head 383f220e9 - digest sha256:eff9d4963a647e... - run 35148205776 | ||||||
v2t253274_2posted Sep 16, 15:15successsupersededstale 3mopg 20
base282111b45 Sep 02, 05:14 - 80 days / 851 commits behind master (from history)
applyapplied Sep 16, 15:17
rebaselast tried Sep 16, 15:17 on fcc0e27f4
Applying: Support UNION DISTINCT ON for non-recursive set operations Patch failed at 0001 Support UNION DISTINCT ON for non-recursive set operations error: sha1 information is lacking or useless (doc/src/sgml/ref/select.sgml). error: could not build fake ancestor hint: Use 'git am --show-current-patch=diff' to see the failed patch hint: When you have resolved this problem, run "git am --continue". hint: If you prefer to skip this patch, run "git am --skip" instead. hint: To restore the original branch and stop patching, run "git am --abort". hint: Disable this message with "git config advice.mergeConflict false"
pushSep 16, 15:17 -> 2e659ec8bbranchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1022 / 1022 | 2m 56s / 5m 41s | docker run ... @sha256:5e8693e... | Sep 16, 15:28 |
run 35114349161executed 1022 - ccache 98 hit / 6526 miss - head 2e659ec8b - digest sha256:5e8693ee17c831... - run 35114349161 | ||||||