ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)

back to CI dashboard

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
ResultAttPGTestsBuild / testImageWhen
success1201070 / 10702m 00s / 4m 38sdocker run ... :t253274about 24 hours ago
run 44919944508
executed 1070 - ccache 78 hit / 6547 miss - head 498286071 - digest sha256:3e884612dc649b... - run 44919944508
success1201069 / 10692m 21s / 4m 53sdocker run ... @sha256:512b654...2 days ago
run 44764542957
executed 1069 - ccache 78 hit / 6547 miss - head 25a5acf07 - digest sha256:512b654174ff77... - run 44764542957
success1201068 / 10681m 59s / 4m 07sdocker run ... @sha256:270fe84...3 days ago
run 44555637210
executed 1068 - ccache 78 hit / 6547 miss - head a69e7d1b5 - digest sha256:270fe8410f0cd7... - run 44555637210
success1201067 / 10673m 09s / 5m 51sdocker run ... @sha256:735a7c6...4 days ago
run 44336339090
executed 1067 - ccache 78 hit / 6547 miss - head 623f70ac4 - digest sha256:735a7c6039bf23... - run 44336339090
success1201067 / 10672m 21s / 4m 43sdocker run ... @sha256:ad24c59...5 days ago
run 44111548912
executed 1067 - ccache 78 hit / 6547 miss - head fbaf8e7a8 - digest sha256:ad24c59c0f0337... - run 44111548912
success1201067 / 10672m 21s / 4m 50sdocker run ... @sha256:ce331fa...6 days ago
run 43893111406
executed 1067 - ccache 78 hit / 6547 miss - head 4bf80d4c3 - digest sha256:ce331fa3cefe7f... - run 43893111406
success1201067 / 10672m 18s / 4m 48sdocker run ... @sha256:9ee8bf6...Nov 15, 10:55
run 43705653056
executed 1067 - ccache 78 hit / 6547 miss - head 095260bcc - digest sha256:9ee8bf6d150f41... - run 43705653056
success1201067 / 10672m 20s / 4m 57sdocker run ... @sha256:4c787b4...Nov 14, 10:54
run 43586754079
executed 1067 - ccache 78 hit / 6547 miss - head ebe092aec - digest sha256:4c787b4f45fcd6... - run 43586754079
success1201067 / 10672m 16s / 4m 30sdocker run ... @sha256:b5e13f4...Nov 13, 10:51
run 43411205444
executed 1067 - ccache 78 hit / 6547 miss - head e49809b1b - digest sha256:b5e13f471554fc... - run 43411205444
success1201067 / 10672m 20s / 4m 59sdocker run ... @sha256:e946536...Nov 12, 10:50
run 43202454584
executed 1067 - ccache 78 hit / 6547 miss - head b16185aa1 - digest sha256:e946536c9a13c5... - run 43202454584
success1201067 / 10673m 04s / 5m 44sdocker run ... @sha256:46aa97b...Nov 11, 10:48
run 43005217180
executed 1067 - ccache 78 hit / 6547 miss - head d9de08aa5 - digest sha256:46aa97b559819b... - run 43005217180
success1201067 / 10672m 55s / 5m 30sdocker run ... @sha256:8591ee8...Nov 10, 10:47
run 42800592648
executed 1067 - ccache 78 hit / 6547 miss - head 5b56ac8ca - digest sha256:8591ee8d9d8966... - run 42800592648
success1201053 / 10531m 51s / 4m 21sdocker run ... @sha256:e05ca98...Nov 09, 10:44
run 42601958455
executed 1053 - ccache 78 hit / 6546 miss - head ab4744431 - digest sha256:e05ca98043f13a... - run 42601958455
success1201053 / 10532m 18s / 4m 54sdocker run ... @sha256:9a9af47...Nov 06, 10:41
run 42203338325
executed 1053 - ccache 78 hit / 6546 miss - head 609c0f22a - digest sha256:9a9af47da683bd... - run 42203338325
success1201053 / 10533m 03s / 5m 39sdocker run ... @sha256:58c34d4...Nov 05, 10:38
run 42010844959
executed 1053 - ccache 78 hit / 6546 miss - head 873626e1d - digest sha256:58c34d4c50c355... - run 42010844959
success1201052 / 10523m 04s / 5m 23sdocker run ... @sha256:7820828...Nov 03, 10:32
run 41618527384
executed 1052 - ccache 78 hit / 6544 miss - head a63e4730b - digest sha256:782082804d5b8b... - run 41618527384
success1201052 / 10523m 06s / 5m 27sdocker run ... @sha256:948a44e...Nov 02, 10:28
run 41427535804
executed 1052 - ccache 78 hit / 6544 miss - head 091a344b5 - digest sha256:948a44ed9d699e... - run 41427535804
success1201051 / 10512m 17s / 4m 47sdocker run ... @sha256:80cbbc2...Nov 01, 10:21
run 41296458884
executed 1051 - ccache 78 hit / 6544 miss - head ab9a38fe3 - digest sha256:80cbbc2eb7c41b... - run 41296458884
success1201051 / 10512m 30s / 4m 33sdocker run ... @sha256:3f5e3b0...Oct 31, 10:19
run 41191649537
executed 1051 - ccache 78 hit / 6544 miss - head 9d49049e0 - digest sha256:3f5e3b08423f71... - run 41191649537
success1201051 / 10512m 53s / 4m 57sdocker run ... @sha256:ffa9b93...Oct 30, 10:18
run 41038500549
executed 1051 - ccache 78 hit / 6544 miss - head 624027802 - digest sha256:ffa9b93305e9e2... - run 41038500549
success1201051 / 10511m 48s / 4m 26sdocker run ... @sha256:dab6e67...Oct 29, 10:15
run 40854893085
executed 1051 - ccache 78 hit / 6544 miss - head b10387a2c - digest sha256:dab6e670b5d68b... - run 40854893085
success1201051 / 10512m 57s / 5m 18sdocker run ... @sha256:d3b97a2...Oct 28, 10:15
run 40669271799
executed 1051 - ccache 78 hit / 6544 miss - head 98adeb14a - digest sha256:d3b97a2313b845... - run 40669271799
success1201050 / 10502m 56s / 5m 45sdocker run ... @sha256:e118c6b...Oct 27, 10:13
run 40485337710
executed 1050 - ccache 78 hit / 6544 miss - head 411a7e6d5 - digest sha256:e118c6b7114496... - run 40485337710
success1201050 / 10502m 09s / 4m 48sdocker run ... @sha256:eb88402...Oct 26, 10:09
run 40303849259
executed 1050 - ccache 78 hit / 6544 miss - head 1c999ab08 - digest sha256:eb8840273c6e16... - run 40303849259
success1201050 / 10502m 58s / 5m 36sdocker run ... @sha256:9c0acc2...Oct 25, 10:08
run 40182757822
executed 1050 - ccache 78 hit / 6544 miss - head fa8a24ed0 - digest sha256:9c0acc20402635... - run 40182757822
success1201050 / 10502m 47s / 5m 09sdocker run ... @sha256:b19bcb6...Oct 24, 10:05
run 40083860738
executed 1050 - ccache 78 hit / 6544 miss - head 35bfd59b2 - digest sha256:b19bcb687377e3... - run 40083860738
success1201050 / 10502m 39s / 4m 51sdocker run ... @sha256:ec38d55...Oct 23, 10:02
run 39934987055
executed 1050 - ccache 78 hit / 6544 miss - head 4b5d69bfc - digest sha256:ec38d55c3959d6... - run 39934987055
success1201050 / 10503m 07s / 5m 42sdocker run ... @sha256:3dc9414...Oct 22, 09:54
run 39757619308
executed 1050 - ccache 78 hit / 6544 miss - head 1daa45d20 - digest sha256:3dc94148483b5d... - run 39757619308
success1201049 / 10492m 51s / 5m 34sdocker run ... @sha256:530df5d...Oct 21, 09:52
run 39578870966
executed 1049 - ccache 78 hit / 6544 miss - head 97acae01f - digest sha256:530df5d797ea0d... - run 39578870966
success1201049 / 10492m 52s / 5m 19sdocker run ... @sha256:857228b...Oct 20, 09:40
run 39401019157
executed 1049 - ccache 78 hit / 6544 miss - head b2a757e2e - digest sha256:857228b66b2edf... - run 39401019157
success1201049 / 10492m 58s / 5m 26sdocker run ... @sha256:6274d04...Oct 19, 09:37
run 39230153529
executed 1049 - ccache 78 hit / 6544 miss - head 0803296c5 - digest sha256:6274d0414939a3... - run 39230153529
success1201049 / 10492m 54s / 5m 35sdocker run ... @sha256:ab7f89e...Oct 18, 09:35
run 39115203935
executed 1049 - ccache 78 hit / 6544 miss - head 05fcb9f08 - digest sha256:ab7f89ed3efd5b... - run 39115203935
success1201049 / 10492m 12s / 4m 27sdocker run ... @sha256:85637b6...Oct 17, 09:31
run 39020861107
executed 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
ResultAttPGTestsBuild / testImageWhen
success1201049 / 10491m 55s / 4m 08sdocker run ... @sha256:82be1f5...Oct 16, 09:28
run 38879712221
executed 1049 - ccache 78 hit / 6544 miss - head cd499cb6c - digest sha256:82be1f54ab7d63... - run 38879712221
success1201049 / 10492m 45s / 5m 19sdocker run ... @sha256:8862a17...Oct 15, 09:27
run 38711855346
executed 1049 - ccache 78 hit / 6544 miss - head 9edafa915 - digest sha256:8862a17b98867e... - run 38711855346
success1201044 / 10442m 17s / 4m 49sdocker run ... @sha256:ee0c030...Oct 14, 09:23
run 38540850893
executed 1044 - ccache 78 hit / 6544 miss - head 925cf55af - digest sha256:ee0c0307b58f23... - run 38540850893
success1201044 / 10442m 44s / 4m 52sdocker run ... @sha256:9e8bae8...Oct 13, 09:20
run 38374336155
executed 1044 - ccache 78 hit / 6544 miss - head 8bccbd9cc - digest sha256:9e8bae8a990689... - run 38374336155
success1201044 / 10442m 55s / 5m 04sdocker run ... @sha256:f9ed3a8...Oct 12, 09:16
run 38227650954
executed 1044 - ccache 78 hit / 6544 miss - head bf9a99943 - digest sha256:f9ed3a8954904a... - run 38227650954
success1201044 / 10442m 10s / 4m 48sdocker run ... @sha256:3ebf1d9...Oct 11, 03:17
run 38107384678
executed 1044 - ccache 78 hit / 6544 miss - head 3e0ee1af9 - digest sha256:3ebf1d9eb8ff70... - run 38107384678
success1201042 / 10422m 52s / 5m 28sdocker run ... @sha256:86623ea...Oct 08, 03:15
run 37720945158
executed 1042 - ccache 78 hit / 6544 miss - head dffa6523f - digest sha256:86623eafc70c91... - run 37720945158
success1201041 / 10412m 32s / 4m 32sdocker run ... @sha256:369bc84...Oct 07, 03:12
run 37564876303
executed 1041 - ccache 78 hit / 6544 miss - head 873946e9f - digest sha256:369bc84fc2bb13... - run 37564876303
success1201039 / 10392m 47s / 5m 06sdocker run ... @sha256:8b5a2f9...Oct 06, 03:11
run 37406950142
executed 1039 - ccache 78 hit / 6544 miss - head 070e5fcb8 - digest sha256:8b5a2f9d304427... - run 37406950142
success1201039 / 10392m 15s / 4m 43sdocker run ... @sha256:61ccddb...Oct 05, 03:09
run 37257610959
executed 1039 - ccache 78 hit / 6544 miss - head 077c3f5b2 - digest sha256:61ccddbb0603b9... - run 37257610959
success1201039 / 10392m 49s / 4m 52sdocker run ... @sha256:14f481b...Oct 04, 03:09
run 37172708625
executed 1039 - ccache 78 hit / 6544 miss - head 7b8c41377 - digest sha256:14f481ba57bb96... - run 37172708625
success1201039 / 10392m 52s / 5m 13sdocker run ... @sha256:cfc3be4...Oct 03, 03:08
run 37091606461
executed 1039 - ccache 78 hit / 6544 miss - head 237124257 - digest sha256:cfc3be45edd162... - run 37091606461
success1201039 / 10391m 44s / 4m 20sdocker run ... @sha256:629238d...Oct 02, 03:05
run 36957983383
executed 1039 - ccache 78 hit / 6544 miss - head 08087b523 - digest sha256:629238dfad49e8... - run 36957983383
success1201039 / 10392m 50s / 5m 19sdocker run ... @sha256:71c2de6...Oct 01, 03:01
run 36807752045
executed 1039 - ccache 78 hit / 6544 miss - head 8ae3dad20 - digest sha256:71c2de6536fdf9... - run 36807752045
success1201039 / 10392m 57s / 5m 36sdocker run ... @sha256:bf2d89e...Sep 30, 03:00
run 36661600830
executed 1039 - ccache 78 hit / 6544 miss - head c0dd2e517 - digest sha256:bf2d89e98fb6e6... - run 36661600830
success1201039 / 10392m 12s / 4m 45sdocker run ... @sha256:a943dd1...Sep 29, 02:57
run 36514333431
executed 1039 - ccache 78 hit / 6544 miss - head c3677930c - digest sha256:a943dd1c043d93... - run 36514333431
success1201039 / 10392m 56s / 5m 30sdocker run ... @sha256:7d6b136...Sep 28, 02:57
run 36371136457
executed 1039 - ccache 78 hit / 6544 miss - head 08dac01df - digest sha256:7d6b136203b6f1... - run 36371136457
success1201039 / 10392m 44s / 4m 41sdocker run ... @sha256:f61918c...Sep 26, 22:10
run 36274830140
executed 1039 - ccache 78 hit / 6544 miss - head 5a2594847 - digest sha256:f61918c75e68e9... - run 36274830140
success1201039 / 10392m 55s / 5m 21sdocker run ... @sha256:1347b22...Sep 25, 22:09
run 36194376544
executed 1039 - ccache 78 hit / 6544 miss - head efc081bdd - digest sha256:1347b22e3d3f2d... - run 36194376544
success1201038 / 10382m 46s / 5m 20sdocker run ... @sha256:3605049...Sep 24, 22:07
run 36064635423
executed 1038 - ccache 78 hit / 6544 miss - head 6cb4758a4 - digest sha256:36050499f4350f... - run 36064635423
success1201036 / 10362m 40s / 4m 35sdocker run ... @sha256:171c602...Sep 23, 22:05
run 35925432525
executed 1036 - ccache 98 hit / 6524 miss - head 116a02d09 - digest sha256:171c602e1f1ada... - run 35925432525
success1201036 / 10362m 55s / 5m 35sdocker run ... @sha256:346bdd8...Sep 22, 22:04
run 35789271674
executed 1036 - ccache 98 hit / 6524 miss - head 8c80a41f9 - digest sha256:346bdd8b98cbbf... - run 35789271674
success1201036 / 10361m 54s / 4m 18sdocker run ... @sha256:9f87156...Sep 21, 21:50
run 35658652090
executed 1036 - ccache 98 hit / 6524 miss - head cb665cf7d - digest sha256:9f87156474cbb1... - run 35658652090
success1201036 / 10362m 38s / 4m 34sdocker run ... @sha256:0ed81da...Sep 20, 20:55
run 35536555679
executed 1036 - ccache 98 hit / 6524 miss - head de5371614 - digest sha256:0ed81da8aa6642... - run 35536555679
success1201036 / 10362m 09s / 4m 42sdocker run ... @sha256:ea40911...Sep 19, 20:53
run 35468322900
executed 1036 - ccache 98 hit / 6524 miss - head deeb2497c - digest sha256:ea40911a05c20b... - run 35468322900
success1201036 / 10362m 10s / 4m 23sdocker run ... @sha256:b53d184...Sep 18, 20:52
run 35392998110
executed 1036 - ccache 98 hit / 6524 miss - head 0cc925b19 - digest sha256:b53d1849152047... - run 35392998110
success1201036 / 10362m 57s / 5m 23sdocker run ... @sha256:53afe11...Sep 17, 20:53
run 35272472858
executed 1036 - ccache 98 hit / 6524 miss - head 7bf0e7225 - digest sha256:53afe11fb31faa... - run 35272472858
success1201036 / 10362m 44s / 5m 27sdocker run ... @sha256:eff9d49...Sep 16, 20:53
run 35148205776
executed 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
ResultAttPGTestsBuild / testImageWhen
success1201022 / 10222m 56s / 5m 41sdocker run ... @sha256:5e8693e...Sep 16, 15:28
run 35114349161
executed 1022 - ccache 98 hit / 6526 miss - head 2e659ec8b - digest sha256:5e8693ee17c831... - run 35114349161