mergeutils.c 3.2 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122
/*-------------------------------------------------------------------------
 *
 * mergeutils.c--
 *    Utilities for finding applicable merge clauses and pathkeys
 *
 * Copyright (c) 1994, Regents of the University of California
 *
 *
 * IDENTIFICATION
 *    $Header: /cvsroot/pgsql/src/backend/optimizer/path/Attic/mergeutils.c,v 1.1.1.1 1996/07/09 06:21:36 scrappy Exp $
 *
 *-------------------------------------------------------------------------
 */
#include "postgres.h"

#include "nodes/pg_list.h"
#include "nodes/relation.h"

#include "optimizer/internal.h"
#include "optimizer/paths.h"
#include "optimizer/clauses.h"
#include "optimizer/ordering.h"

/*    
 * group-clauses-by-order--
 *    If a join clause node in 'clauseinfo-list' is mergesortable, store
 *    it within a mergeinfo node containing other clause nodes with the same
 *    mergesort ordering.
 *    
 * 'clauseinfo-list' is the list of clauseinfo nodes
 * 'inner-relid' is the relid of the inner join relation
 *    
 * Returns the new list of mergeinfo nodes.
 *    
 */
List *
group_clauses_by_order(List *clauseinfo_list,
		       int inner_relid)
{
    List *mergeinfo_list = NIL;
    List *xclauseinfo = NIL;
    
    foreach (xclauseinfo, clauseinfo_list) {
	CInfo *clauseinfo = (CInfo *)lfirst(xclauseinfo);
	MergeOrder *merge_ordering = clauseinfo->mergesortorder;
	
	if (merge_ordering) {
	    /*
	     * Create a new mergeinfo node and add it to
	     * 'mergeinfo-list' if one does not yet exist for this
	     * merge ordering.
	     */
	    PathOrder p_ordering;
	    MInfo *xmergeinfo;
	    Expr *clause = clauseinfo->clause;
	    Var *leftop = get_leftop (clause);
	    Var *rightop = get_rightop (clause);
	    JoinKey *keys;

	    p_ordering.ordtype = MERGE_ORDER;
	    p_ordering.ord.merge = merge_ordering;
	    xmergeinfo =
		match_order_mergeinfo(&p_ordering, mergeinfo_list);
	    if (inner_relid == leftop->varno) {
		keys = makeNode(JoinKey);
		keys->outer = rightop;
		keys->inner = leftop;
	    } else {
		keys = makeNode(JoinKey);
		keys->outer = leftop;
		keys->inner = rightop;
	    } 
	    
	    if (xmergeinfo==NULL) {
		xmergeinfo = makeNode(MInfo);

		xmergeinfo->m_ordering = merge_ordering;
		mergeinfo_list = lcons(xmergeinfo,
				      mergeinfo_list);
	    }
	    
	    ((JoinMethod *)xmergeinfo)->clauses =
		lcons(clause,
		     ((JoinMethod *)xmergeinfo)->clauses);
	    ((JoinMethod *)xmergeinfo)->jmkeys =
		lcons(keys,
		     ((JoinMethod *)xmergeinfo)->jmkeys);
	}
    }
    return(mergeinfo_list);
}


/*    
 * match-order-mergeinfo--
 *    Searches the list 'mergeinfo-list' for a mergeinfo node whose order
 *    field equals 'ordering'.
 *    
 * Returns the node if it exists.
 *    
 */
MInfo *
match_order_mergeinfo(PathOrder *ordering, List *mergeinfo_list)
{
    MergeOrder *xmergeorder;
    List *xmergeinfo = NIL;

    foreach(xmergeinfo, mergeinfo_list) {
	MInfo *mergeinfo = (MInfo*)lfirst(xmergeinfo);

	xmergeorder = mergeinfo->m_ordering;

	if ((ordering->ordtype==MERGE_ORDER &&
	     equal_merge_merge_ordering(ordering->ord.merge, xmergeorder)) ||
	    (ordering->ordtype==SORTOP_ORDER &&
	     equal_path_merge_ordering(ordering->ord.sortop, xmergeorder))) {

	    return (mergeinfo);
	}
    }
    return((MInfo*) NIL);
}