summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/subselect.sql
Commit message (Expand)AuthorAgeFilesLines
* Fix placement of initPlans when forcibly materializing a subplan.Tom Lane2017-02-021-10/+15
* Change unknown-type literals to type text in SELECT and RETURNING lists.Tom Lane2017-01-251-0/+10
* Disallow pushing volatile quals past set-returning functions.Tom Lane2016-09-271-0/+44
* Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.Andres Freund2015-05-081-0/+14
* Allow simplification of EXISTS() subqueries containing LIMIT.Tom Lane2014-11-221-0/+13
* Fix bug with whole-row references to append subplans.Tom Lane2014-07-111-0/+10
* Don't assume a subquery's output is unique if there's a SRF in its tlist.Tom Lane2014-07-081-0/+9
* Disallow pushing volatile qual expressions down into DISTINCT subqueries.Tom Lane2014-06-271-0/+13
* Fix possible crash with nested SubLinks.Tom Lane2013-12-101-0/+11
* Fix crash in assign_collations_walker for EXISTS with empty SELECT list.Tom Lane2013-12-021-0/+6
* Make contain_volatile_functions/contain_mutable_functions look into SubLinks.Tom Lane2013-11-081-0/+16
* Fix grammar for subscripting or field selection from a sub-SELECT result.Tom Lane2013-01-301-0/+15
* Fix cross-type case in partial row matching for hashed subplans.Tom Lane2012-10-111-0/+15
* Fix whole-row Var evaluation to cope with resjunk columns (again).Tom Lane2012-07-201-0/+9
* Unify spelling of "canceled", "canceling", "cancellation"Peter Eisentraut2011-06-291-5/+5
* Fix thinko in previous patch for optimizing EXISTS-within-EXISTS.Tom Lane2011-06-201-0/+9
* Remove useless whitespace at end of linesPeter Eisentraut2010-11-231-2/+2
* Fix potential failure when hashing the output of a subplan that producesTom Lane2010-07-281-0/+6
* Fix "cannot handle unplanned sub-select" error that can occur when aTom Lane2010-07-081-0/+12
* Fix mishandling of whole-row Vars referencing a view or sub-select.Tom Lane2010-06-211-0/+14
* Fix set_subquery_pathlist() to copy the RTE's subquery before it gets mangledTom Lane2009-03-101-0/+11
* Fix mis-calculation of extParam/allParam sets for plan nodes, as seen inTom Lane2008-07-101-0/+26
* Fix convert_IN_to_join to properly handle the case where the subselect'sTom Lane2008-04-211-0/+21
* Fix an old thinko in SS_make_initplan_from_plan, which is used when optimizingTom Lane2007-07-181-0/+15
* Downgrade implicit casts to text to be assignment-only, except for the onesTom Lane2007-06-051-1/+1
* Fix problems with rewriter failing to set Query.hasSubLinks when insertingTom Lane2005-11-231-0/+45
* Fix overenthusiastic optimization of 'x IN (SELECT DISTINCT ...)' and relatedTom Lane2005-07-151-0/+33
* Detect overflow in integer arithmetic operators (integer, smallint, andTom Lane2004-10-041-1/+2
* Repair recalculation failure for nested sub-SELECTs, per bug report fromTom Lane2004-05-111-0/+64
* Repair interaction between IN-join processing and subselect pullup thatTom Lane2003-10-181-0/+18
* Finish implementation of hashed aggregation. Add enable_hashagg GUCTom Lane2002-11-211-1/+1
* subselect regress test was kind of silly; it claimed to test correlationTom Lane2000-03-231-13/+19
* Clean up header for uniform appearance throughout tests.Thomas G. Lockhart2000-01-061-1/+1
* Add new subselect test.Thomas G. Lockhart1998-02-181-0/+71
View Lorry Controller Status