Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

postgres-lambda-diff

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    Tom Lane authored
    We should only run apply_pathtarget_labeling_to_tlist if CP_LABEL_TLIST
    was specified, because only in that case has use_physical_tlist checked
    that the labeling will succeed; otherwise we may get an "ORDER/GROUP BY
    expression not found in targetlist" error.  (This subsumes the previous
    test about gating_clauses, because we reset "flags" to zero earlier
    if there are gating clauses to apply.)
    
    The only known case in which a failure can occur is with a ProjectSet
    path directly atop a table scan path, although it seems likely that there
    are other cases or will be such in future.  This means that the failure
    is currently only visible in the v10 branch: 9.6 didn't have ProjectSet,
    while in v11 and HEAD, apply_scanjoin_target_to_paths for some weird
    reason is using create_projection_path not apply_projection_to_path,
    masking the problem because there's a ProjectionPath in between.
    
    Nonetheless this code is clearly wrong on its own terms, so back-patch
    to 9.6 where this logic was introduced.
    
    Per report from Regina Obe.
    
    Discussion: https://postgr.es/m/001501d40f88$75186950$5f493bf0$@pcorp.us
    4b8860e2
    History
    PostgreSQL Database Management System
    =====================================
    
    This directory contains the source code distribution of the PostgreSQL
    database management system.
    
    PostgreSQL is an advanced object-relational database management system
    that supports an extended subset of the SQL standard, including
    transactions, foreign keys, subqueries, triggers, user-defined types
    and functions.  This distribution also contains C language bindings.
    
    PostgreSQL has many language interfaces, many of which are listed here:
    
    	https://www.postgresql.org/download
    
    See the file INSTALL for instructions on how to build and install
    PostgreSQL.  That file also lists supported operating systems and
    hardware platforms and contains information regarding any other
    software packages that are required to build or run the PostgreSQL
    system.  Copyright and license information can be found in the
    file COPYRIGHT.  A comprehensive documentation set is included in this
    distribution; it can be read as described in the installation
    instructions.
    
    The latest version of this software may be obtained at
    https://www.postgresql.org/download/.  For more information look at our
    web site located at https://www.postgresql.org/.