[HACKERS] Patches that don't apply or don't compile: 2017-09-12

Hello, hackers!

Thanks to the work of Thomas Munro now we have a CI for the patches on
the commitfest [1]. Naturally there is still room for improvement, but
in any case it's much, much better than nothing.

After a short discussion [2] we agreed (or at least no one objected) to
determine the patches that don't apply / don't compile / don't pass
regression tests and have "Needs Review" status, change the status of
these patches to "Waiting on Author" and write a report (this one) with
a CC to the authors. As all we know, we are short on reviewers and this
action will save them a lot of time. Here [3] you can find a script I've
been using to find such patches.

I rechecked the list manually and did my best to exclude the patches
that were updated recently or that depend on other patches. However
there still a chance that your patch got to the list by a mistake. In
this case please let me know.

Unless there are any objections I'm going to re-run this script once or
twice a week during the commitfest and write reports like this one.

Here is the list:

=== Apply Failed: 25 ===
Title: 64-bit transaction identifiers
Author: Tianzhou Chen <tianzhouchen@gmail.com>        (it's a bug - actually Alexander Korotkov)
URL: https://commitfest.postgresql.org/14/1178/

Title: Add and report the new "in_hot_standby" GUC pseudo-variable.
Author: Elvis Pranskevichus <elprans@gmail.com>
URL: https://commitfest.postgresql.org/14/1090/

Title: allow mix of composite and scalar variables in target list
Author: Pavel Stehule <pavel.stehule@gmail.com>
URL: https://commitfest.postgresql.org/14/1139/

Title: Allow users to specify multiple tables in VACUUM commands
Author: "Bossart, Nathan" <bossartn@amazon.com>
URL: https://commitfest.postgresql.org/14/1131/

Title: Controlling toast_tuple_target to tune rows >2kB
Author: Simon Riggs <simon@2ndquadrant.com>
URL: https://commitfest.postgresql.org/14/1284/

Title: Convert join OR clauses into UNION queries
Author: Jim Nasby <Jim.Nasby@BlueTreble.com>
URL: https://commitfest.postgresql.org/14/1001/

Title: faster partition pruning in planner
Author: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
URL: https://commitfest.postgresql.org/14/1272/

Title: Fix race condition between SELECT and ALTER TABLE NO INHERIT
Author: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
URL: https://commitfest.postgresql.org/14/1259/

Title: Gather speed-up
Author: Rafia Sabih <rafia.sabih@enterprisedb.com>
URL: https://commitfest.postgresql.org/14/1156/

Title: Hash partitioning
Authors: Yugo Nagata <nagata@sraoss.co.jp>, "yangjie@highgo.com" <yangjie@highgo.com>
URL: https://commitfest.postgresql.org/14/1059/

Title: Improve compactify_tuples and PageRepairFragmentation
Author: Sokolov Yura <funny.falcon@postgrespro.ru>
URL: https://commitfest.postgresql.org/14/1138/

Title: Improve eval_const_expressions
Author: Heikki Linnakangas <hlinnaka@iki.fi>
URL: https://commitfest.postgresql.org/14/1136/

Title: Incremental sort
Author: Alexander Korotkov <a.korotkov@postgrespro.ru>
URL: https://commitfest.postgresql.org/14/1124/

Title: libpq: Support for Apple Secure Transport SSL library
Author: Daniel Gustafsson <daniel@yesql.se>
URL: https://commitfest.postgresql.org/14/1228/

Title: multivariate MCV lists and histograms
Author: Tomas Vondra <tomas.vondra@2ndquadrant.com>
URL: https://commitfest.postgresql.org/14/1238/

Title: New function for tsquery creation
Author: Victor Drobny <v.drobny@postgrespro.ru>
URL: https://commitfest.postgresql.org/14/1202/

Title: pg_basebackup has stricter tablespace rules than the server
Author: Pierre Ducroquet <p.psql@pinaraf.info>
URL: https://commitfest.postgresql.org/14/1125/

Title: Range Merge Join
Author: Jeff Davis <pgsql@j-davis.com>
URL: https://commitfest.postgresql.org/14/1106/

Title: Retire polyphase merge
Author: Heikki Linnakangas <hlinnaka@iki.fi>
URL: https://commitfest.postgresql.org/14/1267/

Title: Subscription code improvements
Author: Petr Jelinek <petr.jelinek@2ndquadrant.com>
URL: https://commitfest.postgresql.org/14/1248/

Title: Support arrays over domain types
Author: Tom Lane <tgl@sss.pgh.pa.us>
URL: https://commitfest.postgresql.org/14/1235/

Title: Support target_session_attrs=read-only and eliminate the added round-trip to detect session status.
Author: Elvis Pranskevichus <elprans@gmail.com>
URL: https://commitfest.postgresql.org/14/1148/

Title: taking stdbool.h into use
Author: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
URL: https://commitfest.postgresql.org/14/1242/

Title: UPDATE of partition key
Author: Amit Khandekar <amitdkhan.pg@gmail.com>
URL: https://commitfest.postgresql.org/14/1023/

Title: Write Amplification Reduction Method (WARM)
Author: Pavan Deolasee <pavan.deolasee@gmail.com>
URL: https://commitfest.postgresql.org/14/775/


=== Build Failed: 7 ===
Title: Fix the optimization to skip WAL-logging on table created in same transaction
Author: Martijn van Oosterhout <kleptog@svana.org>
URL: https://commitfest.postgresql.org/14/528/

Title: Foreign Key Arrays
Author: Mark Rofail <markm.rofail@gmail.com>
URL: https://commitfest.postgresql.org/14/1252/

Title: Generic type subscripting
Author: Dmitry Dolgov <9erthalion6@gmail.com>
URL: https://commitfest.postgresql.org/14/1062/

Title: new plpgsql extra_checks
Author: Pavel Stehule <pavel.stehule@gmail.com>
URL: https://commitfest.postgresql.org/14/962/

Title: Replication status in logical replication
Author: Masahiko Sawada <sawada.mshk@gmail.com>
URL: https://commitfest.postgresql.org/14/1113/

Title: Restricting maximum keep segments by repslots
Author: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
URL: https://commitfest.postgresql.org/14/1260/

Title: Temporal query processing with range types
Author: Anton Dignös <dignoes@inf.unibz.it>
URL: https://commitfest.postgresql.org/14/839/

Needs Review Total: 120
Failed Total: 32 (26.67 %)



As always, any feedback is very welcomed!

[1]: http://commitfest.cputube.org/
[2]: https://postgr.es/m/CAB7nPqSrHF%2BkNQ6Eq2uy91RcysoCzQr1AjOjkuCn9jvMdJZ6Fw%40mail.gmail.com
[3]: https://github.com/afiskon/py-autoreviewer

--
Best regards,
Aleksander Alekseev