summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/join.sql
Commit message (Expand)AuthorAgeFilesLines
* Fix PlaceHolderVar mechanism's interaction with outer joins.Tom Lane2010-09-281-0/+40
* Fix another join removal bug: the check on PlaceHolderVars was wrong.Tom Lane2010-09-251-0/+15
* Fix join-removal logic for pseudoconstant and outerjoin-delayed quals.Tom Lane2010-09-141-0/+17
* Fix oversight in join removal patch: we have to delete the removed relationTom Lane2010-05-231-0/+6
* Rework join-removal logic as per recent discussion. In particular thisTom Lane2010-03-281-0/+31
* Fix an oversight in join-removal optimization: we have to check not only forTom Lane2010-03-221-0/+23
* Add support for doing FULL JOIN ON FALSE. While this is really a ratherTom Lane2010-01-051-0/+6
* Fix subquery pullup to wrap a PlaceHolderVar around the entire RowExprTom Lane2009-09-021-0/+21
* Add a simple test case covering a join against an inheritance tree,Tom Lane2009-08-131-0/+8
* Fix a thinko in join_is_legal: when we decide we can implement a semijoinTom Lane2009-07-191-0/+10
* Repair bug #4926 "too few pathkeys for mergeclauses". This example showsTom Lane2009-07-171-0/+17
* Get rid of the rather fuzzily defined FlattenedSubLink node type in favor ofTom Lane2009-02-251-0/+10
* Alter regression test cases that rely on the sort order of "aa". SomePeter Eisentraut2009-01-191-7/+7
* Consider a clause to be outerjoin_delayed if it references the nullable sideTom Lane2008-06-271-0/+10
* Fix some planner issues found while investigating Kevin Grittner's reportTom Lane2008-01-091-0/+23
* Rewrite make_outerjoininfo's construction of min_lefthand and min_righthandTom Lane2007-08-311-0/+22
* Fix a bug in the original implementation of redundant-join-clause removal:Tom Lane2007-07-311-0/+16
* Repair planner bug introduced in 8.2 by ability to rearrange outer joins:Tom Lane2007-05-221-0/+25
* Restructure code that is responsible for ensuring that clauseless joins areTom Lane2007-02-161-0/+9
* Fix bug introduced into mergejoin logic by performance improvement patch ofTom Lane2006-03-171-0/+21
* Remove the stub support we had for UNION JOIN; per discussion, this isTom Lane2006-03-071-4/+0
* Fix some issues with missing or too many newlines atTom Lane2005-04-071-1/+1
* Add a "USING" clause to DELETE, which is equivalent to the FROM clauseNeil Conway2005-04-071-0/+24
* As long as we're forcing an ORDER BY in these four join queries, we hadTom Lane2004-12-031-4/+4
* Make some adjustments to reduce platform dependencies in plan selection.Tom Lane2004-12-021-4/+4
* create_unique_plan() should not discard existing output columns of theTom Lane2003-08-071-0/+8
* Fix thinko in new logic about pushing down non-nullability constraints:Tom Lane2003-02-101-0/+39
* Remove /src/utils. Is final cleanup of getopt.c resurection.Bruce Momjian2002-10-301-2/+2
* Add ORDER BY to join regression test.Bruce Momjian2002-10-281-4/+8
* Second try at fixing join alias variables. Instead of attaching miscellaneousTom Lane2002-04-281-0/+72
* Restructure representation of join alias variables. An explicit JOINTom Lane2002-03-121-1/+22
* Add explicit ORDER BYs in a couple of cases --- seems to be necessaryTom Lane2000-11-061-2/+4
* Add tests for more INTERVAL syntax.Thomas G. Lockhart2000-11-061-15/+31
* First cut at full support for OUTER JOINs. There are still a few looseTom Lane2000-09-121-11/+11
* Update "join syntax" test for new capabilities.Thomas G. Lockhart2000-02-151-30/+87
* Clean up header for uniform appearance throughout tests.Thomas G. Lockhart2000-01-061-2/+1
* Clean up format of tests.Thomas G. Lockhart2000-01-051-18/+64
* First tests using JOIN syntax.Thomas G. Lockhart1999-02-231-0/+87