summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/union.sql
AgeCommit message (Expand)Author
2025-11-06Fix UNION planner estimate_num_groups with varno==0David Rowley
2025-10-07Teach planner to short-circuit EXCEPT/INTERSECT with dummy inputsDavid Rowley
2025-10-07Fix incorrect targetlist in dummy UNIONsDavid Rowley
2025-10-04Teach UNION planner to remove dummy inputsDavid Rowley
2024-12-19Improve planner's handling of SetOp plans.Tom Lane
2024-12-19Convert SetOp to read its inputs as outerPlan and innerPlan.Tom Lane
2024-05-21Fix generate_union_paths for non-sortable types.REL_17_BETA1Robert Haas
2024-05-21Re-allow planner to use Merge Append to efficiently implement UNION.Robert Haas
2024-05-20Revert commit 66c0185a3 and follow-on patches.Tom Lane
2024-04-01Fix assert failure when planning setop subqueries with CTEsDavid Rowley
2024-03-25Allow planner to use Merge Append to efficiently implement UNIONDavid Rowley
2024-02-16Attempt to stabilize flapping regression testDavid Rowley
2024-01-15Reduce dependency to money data type in main regression test suiteMichael Paquier
2023-10-10Fix possible crash in add_paths_to_append_rel()David Rowley
2023-10-05Consider cheap startup paths in add_paths_to_append_relDavid Rowley
2021-09-08Disable anonymous record hash support except in special casesPeter Eisentraut
2020-11-19Hash support for row typesPeter Eisentraut
2020-11-18Add more tests for hashing and hash-based plansPeter Eisentraut
2019-05-09Repair issues with faulty generation of merge-append plans.Tom Lane
2017-12-22Fix UNION/INTERSECT/EXCEPT over no columns.Tom Lane
2017-08-11Add regression tests exercising the non-hashed code paths in nodeSetop.c.Tom Lane
2017-04-07Fix planner error (or assert trap) with nested set operations.Tom Lane
2017-01-19Fix Assert failure induced by commit 215b43cdc.Tom Lane
2016-10-10Make regression tests less dependent on hash table order.Andres Freund
2014-06-26Forward-patch regression test for "could not find pathkey item to sort".Tom Lane
2014-03-28Fix EquivalenceClass processing for nested append relations.Tom Lane
2013-08-02Fix crash in error report of invalid tuple lockAlvaro Herrera
2013-07-08Fix planning of parameterized appendrel paths with expensive join quals.Tom Lane
2013-06-06Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT nests.Tom Lane
2012-03-16Revisit handling of UNION ALL subqueries with non-Var output columns.Tom Lane
2012-01-29Fix pushing of index-expression qualifications through UNION ALL.Tom Lane
2009-12-16Avoid a premature coercion failure in transformSetOperationTree() whenTom Lane
2008-08-07Support hashing for duplicate-elimination in INTERSECT and EXCEPT queries.Tom Lane
2008-08-07Teach the system how to use hashing for UNION. (INTERSECT/EXCEPT will follow,Tom Lane
2003-11-02Adjust data types in some of the UNION tests to avoid potentiallyTom Lane
2003-05-26Cause CHAR(n) to TEXT or VARCHAR conversion to automatically strip trailingTom Lane
2000-11-09Add some more union/intersect/except test cases, per suggestionsTom Lane
2000-10-05Reimplementation of UNION/INTERSECT/EXCEPT. INTERSECT/EXCEPT now meet theTom Lane
2000-01-06Clean up header for uniform appearance throughout tests.Thomas G. Lockhart
1998-05-29Add test for UNION.Thomas G. Lockhart