* docs - add plan cache invalidation info

* use correct postgres version, remove reuse statement

Signed-off-by: NJesse Zhang <sbjesse@gmail.com>

CID 167715: Incorrect Expression (UNINTENDED_INTEGER_DIVISION)
Covertiy reported that a division operation of two integers is then
converted to a double. This would cause any fractional part of the
quotient to be lost. This is fixed by casting the divisor to a double
before the division.

CID 167714: Dereference before null check (REVERSE_INULL)
Coverity reported that a null check is unnecessary because the pointer
spill_file->file_info is dereferenced before this line in every code
path. This issue is fixed by removing the null pointer check

This commit fixes a bug where a SharedInputScan with a Redistribute
Motion in its subtree that is also shared within the same slice may not
execute the SharedInputScan and stop the Motion prematurely. To avoid
this issue squelchNodeWalker() short-circuits if it comes across a
ShareInputScan in its subtree that is shared within the same slice

0, default database doesn't exist in some env.
1, reports good even the cases failed.
2, init_file ignores too many lines.

This commit fixes these.

This is a partial backport of f9e9da66 from upstream needed
to get contrib/orca_debug building on macOS:

  commit f9e9da66
  Author: Tom Lane <tgl@sss.pgh.pa.us>
  Date:   Mon Jul 5 23:15:56 2010 +0000

	Fix a few single-file (MODULES, not MODULE_big) contrib makefiles that were
	supposing that they should set SHLIB_LINK rather than LDFLAGS_SL.  Since these
	don't go through Makefile.shlib that was a no-op on most platforms.  Also
	regularize the few platform-specific Makefiles that did pay attention to
	SHLIB_LINK: it seems that the real value of that is to pull in BE_DLLLIBS,
	so do that instead.  Per buildfarm failures on cygwin.

The orca_debug contrib module was in disrepair and no longer
compiled due to changes in the version strings. Fix the code
and also add the proper libraries to link against to give the
.so a fighting chance to compile. Override the compiler in the
Makefile to use a C++ compiler instead.

Functions already compiled in when building GPDB with Orca were
removed, missing prototypes added and an unused function removed.
This allows orca_debug to compile without warnings.

Deleting the backup directory will sometimes fail if the directory does
not exist. Check for backup directory existence on DD before
attempting to delete.

This checks for environment variables provided through pulse if they
exist.

* Add RENAME TO option

* Fix typo

* Remove unsupported option

Commit c79f51a1 incorrectly set proisstrict to false on some of
the json functions which indeed are strict. Fix by updating the
pg_proc entries. Bumps the catalog and includes the latest catalog
json in gppylib and adds a test for the case that caught this bug.

When splitting the Greenplum and PostgreSQL versioning in autoconf,
the wrong variable was used when building the version string. Also
add a test for it in ICW to catch it in case it would happen again.

There is a lot of tab/space confusion in the code, this fixes some
of the worst offenders but there is lots of low-hanging fruit left.

There was a lot of unused code in the gpMgmt bash code that hasn't
been running for quite some time. On top of really dead code, some
codepaths were reachable, but useless (like printing a non-existing
version string). Remove the dead code and replace the version print
with working code which pulls the version from the canonical source.

Mainly fix spacing to avoid rendering the docs as "--option =val"
but also some small superflous whitespace cleanups.

The option description should aptly describe what the option is and
how it's used, a shorter version is not required. Also, the short
version could be mistaken for a parameter to pass in on a quick eye
so remove.

Signed-off-by: NChris Hajas <c.hajas@pivotal.io>

These tests do not ideally test gptransfer functionality,
so removing them from the suite.
Signed-off-by: NChris Hajas <c.hajas@pivotal.io>

Signed-off-by: NChris Hajas <c.hajas@pivotal.io>

ORCA and planner answer files are similar, so we need not have
additional ORCA answer files.

With this porting, we support multiple reader in tuplestore. Also we did the
following modification:
 * Modified tuplestore to use GPDB's MemTuple.
 * Changed Buffile API to take file number.

Signed-off-by: NTom Meyer <tmeyer@pivotal.io>

Also bump ivy.xml third-party/ext 3.2 configuration to use the latest
tarball
Signed-off-by: NJingyi Mei <jmei@pivotal.io>

- Initial commit to start testing on a dev pipeline
Signed-off-by: NJingyi Mei <jmei@pivotal.io>

Remove xslice in prepare_plan_for_sharing, since it is always false.  cross
slice share type will be updated in function shareinput_mutator_xslice_2 and
shareinput_mutator_xslice_3.

The demo makes sense to keep but colocate with gpmapreduce rather
than keeping it in gpMgmt where it seems out of place. Also avoid
installing it.

The bundled tests no longer worked, and looking at their setup they
probably haven't worked for some time. We already have tests for
gpmapreduce in src/test/regress covering the usecases (and expected
lifespan of the product) so kill these rather than resuscitate.

Signed-off-by: NC.J. Jameson <cjameson@pivotal.io>

Signed-off-by: NLarry Hamel <lhamel@pivotal.io>

Signed-off-by: NMarbin Tan <mtan@pivotal.io>

Simplify the implementation of UnpackCheckPointRecord() by alligning it to our
current checkpoint structure and removing all dead old code.

Fixes #2115.