Skip to content
Snippets Groups Projects
  • Bruce Momjian's avatar
    460b20a4
    1) Queries using the having clause on base tables should work well · 460b20a4
    Bruce Momjian authored
       now. Here some tested features, (examples included in the patch):
    
    1.1) Subselects in the having clause 1.2) Double nested subselects
    1.3) Subselects used in the where clause and in the having clause
         simultaneously 1.4) Union Selects using having 1.5) Indexes
    on the base relations are used correctly 1.6) Unallowed Queries
    are prevented (e.g. qualifications in the
         having clause that belong to the where clause) 1.7) Insert
    into as select
    
    2) Queries using the having clause on view relations also work
       but there are some restrictions:
    
    2.1) Create View as Select ... Having ...; using base tables in
    the select 2.1.1) The Query rewrite system:
    
    2.1.2) Why are only simple queries allowed against a view from 2.1)
    ? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug
    in ExecMergeJoin ??
    
    
    Regards Stefan
    460b20a4
    History
    1) Queries using the having clause on base tables should work well
    Bruce Momjian authored
       now. Here some tested features, (examples included in the patch):
    
    1.1) Subselects in the having clause 1.2) Double nested subselects
    1.3) Subselects used in the where clause and in the having clause
         simultaneously 1.4) Union Selects using having 1.5) Indexes
    on the base relations are used correctly 1.6) Unallowed Queries
    are prevented (e.g. qualifications in the
         having clause that belong to the where clause) 1.7) Insert
    into as select
    
    2) Queries using the having clause on view relations also work
       but there are some restrictions:
    
    2.1) Create View as Select ... Having ...; using base tables in
    the select 2.1.1) The Query rewrite system:
    
    2.1.2) Why are only simple queries allowed against a view from 2.1)
    ? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug
    in ExecMergeJoin ??
    
    
    Regards Stefan