gpdb
gpdb copied to clipboard
Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
This PR resolves a FIXME in `src/backend/optimizer/prep/prepunion.c`. ## Here are some reminders before you submit the pull request - [ ] Add tests for the change - [ ] Document...
The anyarray coercion hack was added circa 2008 to accommodate INSERT statements into catalog tables such as pg_statistic, which sport the anyarray type - a pseudo-type that does not handle...
This PR mainly involves synchronizing the main branch with the multithreaded compression transmission functionality for gpfdist external table. It includes the following features: - compression and decompression of data transmitted...
## Bug Report Planner doesn't always optimize project info for External Table FDW. ### Expected behavior A plan similar to ORCA plan where foreign scan outputs only column 'a'. ```...
In order to avoid needless motion. about issue #16315, https://github.com/greenplum-db/gpdb/issues/16315. Just keep redundant restrict in redistribute clauses. Redistribute clauses is not bother pathkey which mergeclause_list considered. Redistribute clauses is not...
This is for fix issue https://github.com/greenplum-db/gpdb/issues/16866. On GPDB6, it will pull up the sublink to a laterial join, which will result error "illegal rescan of motion node". PG doesn't do...
1、In gpdb7 there are a few testcases will still cause panic. Backport "check whether motion contains nestloop params" from 6X_STABLE to gpdb7. If we pass params by a motion, throw...
greenplum database 6 and 7 support event triggers. add EVENT TRIGGER sql reference pages based on postgres 12 content and a "using" topic. in this PR: - ALTER EVENT TRIGGER...
## Bug Report Setup: ``` create user user1; create table root (a int, b int) partition by range(a); create table leaf1 partition of root for values from (0) to (10);...
In Table-Value Expressions, `SCATTER BY 1` will redistribute the data by constant number `1` instead of the first column. However, the example in the doc implies that `SCATTER BY 1`...