summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/join.sql
Commit message (Expand)AuthorAgeFilesLines
* Add explicit ORDER BY to a few tests that exercise hash-join code.Andres Freund2017-02-081-2/+4
* Fix typos in comments.Heikki Linnakangas2017-02-061-1/+1
* Fix mishandling of equivalence-class tests in parameterized plans.Tom Lane2016-04-291-0/+17
* Fix planner failure with full join in RHS of left join.Tom Lane2016-04-211-0/+17
* Remove GROUP BY columns that are functionally dependent on other columns.Tom Lane2016-02-111-1/+3
* ExecHashRemoveNextSkewBucket must physically copy tuples to main hashtable.Tom Lane2016-02-071-0/+16
* Still more fixes for planner's handling of LATERAL references.Tom Lane2015-12-111-0/+59
* Fix another oversight in checking if a join with LATERAL refs is legal.Tom Lane2015-12-071-0/+19
* Improve regression test case to avoid depending on system catalog stats.Tom Lane2015-08-131-21/+9
* Undo mistaken tightening in join_is_legal().Tom Lane2015-08-121-0/+19
* Postpone extParam/allParam calculations until the very end of planning.Tom Lane2015-08-111-0/+21
* Further mucking with PlaceHolderVar-related restrictions on join order.Tom Lane2015-08-101-0/+18
* Further adjustments to PlaceHolderVar removal.Tom Lane2015-08-071-0/+25
* Fix old oversight in join removal logic.Tom Lane2015-08-061-0/+15
* Further fixes for degenerate outer join clauses.Tom Lane2015-08-061-0/+25
* Fix a PlaceHolderVar-related oversight in star-schema planning patch.Tom Lane2015-08-041-0/+31
* Fix some planner issues with degenerate outer join clauses.Tom Lane2015-08-011-0/+50
* Fix an oversight in checking whether a join with LATERAL refs is legal.Tom Lane2015-07-311-0/+13
* Remove an unsafe Assert, and explain join_clause_is_movable_into() better.Tom Lane2015-07-281-0/+26
* Fix oversight in flattening of subqueries with empty FROM.Tom Lane2015-07-261-0/+13
* Make entirely-dummy appendrels get marked as such in set_append_rel_size.Tom Lane2015-07-261-0/+12
* Prevent improper reordering of antijoins vs. outer joins.Tom Lane2015-04-251-0/+17
* Fix incorrect matching of subexpressions in outer-join plan nodes.Tom Lane2015-04-041-0/+20
* Support flattening of empty-FROM subqueries and one-row VALUES tables.Tom Lane2015-03-111-3/+10
* Fix old bug in get_loop_count().Tom Lane2015-03-111-2/+2
* Suggest to the user the column they may have meant to reference.Robert Haas2015-03-111-0/+24
* Fix planning of star-schema-style queries.Tom Lane2015-02-281-0/+9
* Preserve AND/OR flatness while extracting restriction OR clauses.Tom Lane2014-09-091-0/+4
* Allow join removal in some cases involving a left join to a subquery.Tom Lane2014-07-151-0/+35
* Forward-port regression test for bug #10587 into 9.3 and HEAD.Tom Lane2014-06-091-0/+58
* Revert "Auto-tune effective_cache size to be 4x shared buffers"Tom Lane2014-05-081-2/+0
* Fix bogus handling of "postponed" lateral quals.Tom Lane2014-01-301-0/+8
* Disallow LATERAL references to the target table of an UPDATE/DELETE.Tom Lane2014-01-111-7/+6
* Fix LATERAL references to target table of UPDATE/DELETE.Tom Lane2014-01-071-0/+18
* Extract restriction OR clauses whether or not they are indexable.Tom Lane2013-12-301-0/+12
* Tweak placement of explicit ANALYZE commands in the regression tests.Tom Lane2013-12-111-2/+0
* Flatten join alias Vars before pulling up targetlist items from a subquery.Tom Lane2013-11-221-0/+31
* Compute correct em_nullable_relids in get_eclass_for_sort_expr().Tom Lane2013-11-151-0/+13
* Re-allow duplicate aliases within aliased JOINs.Tom Lane2013-11-111-0/+12
* Auto-tune effective_cache size to be 4x shared buffersBruce Momjian2013-10-081-0/+2
* Fix qual-clause-misplacement issues with pulled-up LATERAL subqueries.Tom Lane2013-08-191-0/+9
* Fix planner problems with LATERAL references in PlaceHolderVars.Tom Lane2013-08-171-0/+41
* Remove ph_may_need from PlaceHolderInfo, with attendant simplifications.Tom Lane2013-08-141-0/+13
* Postpone creation of pathkeys lists to fix bug #8049.Tom Lane2013-04-291-0/+17
* Make LATERAL implicit for functions in FROM.Tom Lane2013-01-261-5/+8
* Fix planning of non-strict equivalence clauses above outer joins.Tom Lane2012-10-181-0/+32
* Rethink heuristics for choosing index quals for parameterized paths.Tom Lane2012-09-161-2/+2
* Drop cheap-startup-cost paths during add_path() if we don't need them.Tom Lane2012-09-011-0/+1
* Fix mark_placeholder_maybe_needed to handle LATERAL references.Tom Lane2012-09-011-0/+11
* Fix LATERAL references to join alias variables.Tom Lane2012-08-311-0/+8
View Lorry Controller Status