From 3eb1c8227751aecede58e742a13b07127a7e2652 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 7 Oct 1999 04:23:24 +0000 Subject: Fix planner and rewriter to follow SQL semantics for tables that are mentioned in FROM but not elsewhere in the query: such tables should be joined over anyway. Aside from being more standards-compliant, this allows removal of some very ugly hacks for COUNT(*) processing. Also, allow HAVING clause without aggregate functions, since SQL does. Clean up CREATE RULE statement-list syntax the same way Bruce just fixed the main stmtmulti production. CAUTION: addition of a field to RangeTblEntry nodes breaks stored rules; you will have to initdb if you have any rules. --- src/include/optimizer/planmain.h | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) (limited to 'src/include/optimizer/planmain.h') diff --git a/src/include/optimizer/planmain.h b/src/include/optimizer/planmain.h index 09c39ceea7..8664fb9aaa 100644 --- a/src/include/optimizer/planmain.h +++ b/src/include/optimizer/planmain.h @@ -6,7 +6,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: planmain.h,v 1.33 1999/08/22 23:56:43 tgl Exp $ + * $Id: planmain.h,v 1.34 1999/10/07 04:23:19 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -19,9 +19,7 @@ /* * prototypes for plan/planmain.c */ -extern Plan *query_planner(Query *root, - int command_type, List *tlist, List *qual); - +extern Plan *query_planner(Query *root, List *tlist, List *qual); /* * prototypes for plan/createplan.c @@ -42,8 +40,8 @@ extern Result *make_result(List *tlist, Node *resconstantqual, Plan *subplan); */ extern void make_var_only_tlist(Query *root, List *tlist); extern void add_restrict_and_join_to_rels(Query *root, List *clauses); +extern void add_missing_rels_to_query(Query *root); extern void set_joininfo_mergeable_hashable(List *rel_list); -extern void add_missing_vars_to_tlist(Query *root, List *tlist); /* * prototypes for plan/setrefs.c -- cgit v1.2.1