← Back to branch summary

~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

« back to all changes in this revision

Viewing changes to src/backend/optimizer/path/allpaths.c

Committer: Package Import Robot
Author(s): Martin Pitt
Date: 2012-09-25 07:38:24 UTC
mfrom: (1.3.8) (12.1.6 lucid-security)
Revision ID: package-import@ubuntu.com-20120925073824-w62lp3agkr8dwnoc

Tags: 8.4.14-0ubuntu10.04

https://launchpad.net/bugs/1055944

* New upstream bug fix release: (LP: #1055944)
  - Fix planner's assignment of executor parameters, and fix executor's
    rescan logic for CTE plan nodes.
    These errors could result in wrong answers from queries that scan
    the same WITH subquery multiple times.
  - Improve page-splitting decisions in GiST indexes.
    Multi-column GiST indexes might suffer unexpected bloat due to this
    error.
  - Fix cascading privilege revoke to stop if privileges are still held.
    If we revoke a grant option from some role "X", but "X" still holds
    that option via a grant from someone else, we should not
    recursively revoke the corresponding privilege from role(s) "Y"
    that "X" had granted it to.
  - Fix handling of SIGFPE when PL/Perl is in use.
    Perl resets the process's SIGFPE handler to SIG_IGN, which could
    result in crashes later on. Restore the normal Postgres signal
    handler after initializing PL/Perl.
  - Prevent PL/Perl from crashing if a recursive PL/Perl function is
    redefined while being executed.
  - Work around possible misoptimization in PL/Perl.
    Some Linux distributions contain an incorrect version of
    "pthread.h" that results in incorrect compiled code in PL/Perl,
    leading to crashes if a PL/Perl function calls another one that
    throws an error.

files added:
src/backend/po/ru.po

src/backend/regex/regprefix.c

src/bin/pg_controldata/po/ru.po

src/bin/pg_dump/po/ru.po

src/bin/psql/po/ru.po

src/bin/scripts/po/ru.po

src/interfaces/ecpg/ecpglib/po/ru.po

src/interfaces/ecpg/preproc/po/ru.po

src/pl/plperl/po/ru.po

src/pl/plpgsql/src/po/ru.po

src/pl/plpython/po/ru.po

src/pl/tcl/po/ru.po

files removed:
debian/patches/00git_inet_cidr_unpack.patch

debian/patches/04-armel-tas.patch

files modified:
HISTORY

INSTALL

config/python.m4

configure

configure.in

contrib/dblink/dblink.c

contrib/dblink/expected/dblink.out

contrib/intarray/_int_tool.c

contrib/intarray/expected/_int.out

contrib/intarray/sql/_int.sql

contrib/pgcrypto/crypt-des.c

contrib/pgcrypto/pgcrypto.c

contrib/test_parser/test_parser.c

contrib/xml2/expected/xml2.out

contrib/xml2/expected/xml2_1.out

contrib/xml2/sql/xml2.sql

contrib/xml2/xslt_proc.c

debian/changelog

debian/control

doc/bug.template

doc/man.tar.gz

doc/postgres.tar.gz

doc/src/sgml/auto-explain.sgml

doc/src/sgml/backup.sgml

doc/src/sgml/config.sgml

doc/src/sgml/ddl.sgml

doc/src/sgml/external-projects.sgml

doc/src/sgml/legal.sgml

doc/src/sgml/libpq.sgml

doc/src/sgml/maintenance.sgml

doc/src/sgml/queries.sgml

doc/src/sgml/ref/alter_table.sgml

doc/src/sgml/ref/create_trigger.sgml

doc/src/sgml/ref/delete.sgml

doc/src/sgml/ref/initdb.sgml

doc/src/sgml/ref/lock.sgml

doc/src/sgml/ref/select.sgml

doc/src/sgml/ref/truncate.sgml

doc/src/sgml/ref/update.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/trigger.sgml

doc/src/sgml/xml2.sgml

src/backend/access/gin/ginxlog.c

src/backend/access/gist/gistutil.c

src/backend/access/heap/heapam.c

src/backend/access/index/genam.c

src/backend/access/nbtree/README

src/backend/access/nbtree/nbtinsert.c

src/backend/access/nbtree/nbtpage.c

src/backend/access/nbtree/nbtree.c

src/backend/access/transam/twophase.c

src/backend/access/transam/xact.c

src/backend/access/transam/xlog.c

src/backend/catalog/storage.c

src/backend/commands/copy.c

src/backend/commands/sequence.c

src/backend/commands/tablecmds.c

src/backend/commands/tablespace.c

src/backend/commands/trigger.c

src/backend/executor/execMain.c

src/backend/executor/execQual.c

src/backend/executor/execUtils.c

src/backend/executor/nodeCtescan.c

src/backend/executor/nodeSubplan.c

src/backend/libpq/be-secure.c

src/backend/nls.mk

src/backend/nodes/copyfuncs.c

src/backend/nodes/equalfuncs.c

src/backend/nodes/outfuncs.c

src/backend/optimizer/path/allpaths.c

src/backend/optimizer/path/costsize.c

src/backend/optimizer/path/indxpath.c

src/backend/optimizer/plan/planner.c

src/backend/optimizer/plan/subselect.c

src/backend/optimizer/prep/prepjointree.c

src/backend/optimizer/prep/prepunion.c

src/backend/parser/analyze.c

src/backend/parser/parse_cte.c

src/backend/parser/parse_utilcmd.c

src/backend/po/de.po

src/backend/po/es.po

src/backend/po/fr.po

src/backend/po/pt_BR.po

src/backend/po/tr.po

src/backend/po/zh_CN.po

src/backend/po/zh_TW.po

src/backend/port/win32_sema.c

src/backend/postmaster/bgwriter.c

src/backend/postmaster/postmaster.c

src/backend/postmaster/syslogger.c

src/backend/regex/Makefile

src/backend/regex/regc_color.c

src/backend/regex/regc_nfa.c

src/backend/regex/regcomp.c

src/backend/regex/rege_dfa.c

src/backend/regex/regexec.c

src/backend/rewrite/rewriteManip.c

src/backend/storage/lmgr/deadlock.c

src/backend/storage/lmgr/proc.c

src/backend/storage/smgr/md.c

src/backend/tcop/postgres.c

src/backend/tsearch/to_tsany.c

src/backend/utils/adt/acl.c

src/backend/utils/adt/date.c

src/backend/utils/adt/datetime.c

src/backend/utils/adt/name.c

src/backend/utils/adt/network.c

src/backend/utils/adt/regexp.c

src/backend/utils/adt/ruleutils.c

src/backend/utils/adt/selfuncs.c

src/backend/utils/adt/varchar.c

src/backend/utils/adt/varlena.c

src/backend/utils/adt/xml.c

src/backend/utils/cache/ts_cache.c

src/backend/utils/fmgr/fmgr.c

src/backend/utils/mb/mbutils.c

src/backend/utils/mb/wchar.c

src/bin/initdb/initdb.c

src/bin/initdb/po/cs.po

src/bin/initdb/po/de.po

src/bin/initdb/po/es.po

src/bin/initdb/po/fr.po

src/bin/initdb/po/pl.po

src/bin/initdb/po/ru.po

src/bin/initdb/po/zh_CN.po

src/bin/pg_config/po/de.po

src/bin/pg_config/po/es.po

src/bin/pg_config/po/fr.po

src/bin/pg_config/po/pl.po

src/bin/pg_config/po/ru.po

src/bin/pg_controldata/nls.mk

src/bin/pg_controldata/po/de.po

src/bin/pg_controldata/po/es.po

src/bin/pg_controldata/po/fr.po

src/bin/pg_controldata/po/pl.po

src/bin/pg_ctl/po/de.po

src/bin/pg_ctl/po/es.po

src/bin/pg_ctl/po/fr.po

src/bin/pg_ctl/po/ru.po

src/bin/pg_dump/common.c

src/bin/pg_dump/nls.mk

src/bin/pg_dump/pg_backup_archiver.c

src/bin/pg_dump/pg_backup_archiver.h

src/bin/pg_dump/pg_backup_db.c

src/bin/pg_dump/pg_backup_tar.c

src/bin/pg_dump/pg_dump.c

src/bin/pg_dump/pg_dump.h

src/bin/pg_dump/pg_dump_sort.c

src/bin/pg_dump/po/de.po

src/bin/pg_dump/po/es.po

src/bin/pg_dump/po/fr.po

src/bin/pg_dump/po/sv.po

src/bin/pg_resetxlog/po/de.po

src/bin/pg_resetxlog/po/es.po

src/bin/pg_resetxlog/po/fr.po

src/bin/pg_resetxlog/po/ru.po

src/bin/psql/nls.mk

src/bin/psql/po/de.po

src/bin/psql/po/es.po

src/bin/psql/po/fr.po

src/bin/psql/po/ko.po

src/bin/psql/po/sv.po

src/bin/psql/print.c

src/bin/psql/sql_help.h

src/bin/scripts/nls.mk

src/bin/scripts/po/de.po

src/bin/scripts/po/es.po

src/bin/scripts/po/fr.po

src/include/access/nbtree.h

src/include/commands/tablecmds.h

src/include/libpq/libpq-be.h

src/include/mb/pg_wchar.h

src/include/miscadmin.h

src/include/nodes/execnodes.h

src/include/nodes/nodes.h

src/include/nodes/relation.h

src/include/pg_config.h.in

src/include/pg_config.h.win32

src/include/regex/regex.h

src/include/regex/regguts.h

src/include/rewrite/rewriteManip.h

src/include/storage/relfilenode.h

src/include/storage/s_lock.h

src/include/utils/builtins.h

src/include/utils/inet.h

src/include/utils/selfuncs.h

src/include/utils/timestamp.h

src/interfaces/ecpg/ecpglib/nls.mk

src/interfaces/ecpg/ecpglib/po/de.po

src/interfaces/ecpg/ecpglib/po/es.po

src/interfaces/ecpg/ecpglib/po/fr.po

src/interfaces/ecpg/preproc/ecpg.addons

src/interfaces/ecpg/preproc/nls.mk

src/interfaces/ecpg/preproc/po/de.po

src/interfaces/ecpg/preproc/po/es.po

src/interfaces/ecpg/preproc/po/fr.po

src/interfaces/ecpg/preproc/preproc.c

src/interfaces/ecpg/preproc/preproc.y

src/interfaces/libpq/fe-secure.c

src/interfaces/libpq/libpq-dist.rc

src/interfaces/libpq/libpq-int.h

src/interfaces/libpq/libpq.rc.in

src/interfaces/libpq/po/de.po

src/interfaces/libpq/po/es.po

src/interfaces/libpq/po/fr.po

src/interfaces/libpq/po/it.po

src/interfaces/libpq/po/pt_BR.po

src/interfaces/libpq/po/ru.po

src/interfaces/libpq/po/sv.po

src/interfaces/libpq/po/zh_CN.po

src/interfaces/libpq/po/zh_TW.po

src/pl/plperl/expected/plperl.out

src/pl/plperl/nls.mk

src/pl/plperl/plperl.c

src/pl/plperl/po/de.po

src/pl/plperl/po/es.po

src/pl/plperl/po/fr.po

src/pl/plperl/sql/plperl.sql

src/pl/plpgsql/src/nls.mk

src/pl/plpgsql/src/pl_exec.c

src/pl/plpgsql/src/po/de.po

src/pl/plpgsql/src/po/es.po

src/pl/plpgsql/src/po/fr.po

src/pl/plpython/nls.mk

src/pl/plpython/po/de.po

src/pl/plpython/po/es.po

src/pl/plpython/po/fr.po

src/pl/tcl/nls.mk

src/pl/tcl/po/de.po

src/pl/tcl/po/es.po

src/pl/tcl/po/fr.po

src/port/exec.c

src/port/path.c

src/port/win32ver.rc

src/test/regress/expected/copy2.out

src/test/regress/expected/interval.out

src/test/regress/expected/join.out

src/test/regress/expected/privileges.out

src/test/regress/expected/select_into.out

src/test/regress/expected/sequence.out

src/test/regress/expected/sequence_1.out

src/test/regress/expected/subselect.out

src/test/regress/expected/with.out

src/test/regress/expected/xml.out

src/test/regress/expected/xml_1.out

src/test/regress/pg_regress.c

src/test/regress/sql/copy2.sql

src/test/regress/sql/interval.sql

src/test/regress/sql/join.sql

src/test/regress/sql/privileges.sql

src/test/regress/sql/select_into.sql

src/test/regress/sql/subselect.sql

src/test/regress/sql/with.sql

src/test/regress/sql/xml.sql

src/timezone/data/africa

src/timezone/data/antarctica

src/timezone/data/asia

src/timezone/data/australasia

src/timezone/data/backward

src/timezone/data/etcetera

src/timezone/data/europe

src/timezone/data/factory

src/timezone/data/iso3166.tab

src/timezone/data/leapseconds

src/timezone/data/northamerica

src/timezone/data/pacificnew

src/timezone/data/solar87

src/timezone/data/solar88

src/timezone/data/solar89

src/timezone/data/southamerica

src/timezone/data/systemv

src/timezone/data/yearistype.sh

src/timezone/data/zone.tab

src/timezone/localtime.c

Show diffs side-by-side

added added

removed removed

src/backend/optimizer/path/allpaths.c

626

626

else

627

627

tuple_fraction = root->tuple_fraction;

628

628

629

/* plan_params should not be in use in current query level */

630

Assert(root->plan_params == NIL);

631

629

632

/* Generate the plan for the subquery */

630

633

rel->subplan = subquery_planner(root->glob, subquery,

631

634

root,

633

636

&subroot);

634

637

rel->subrtable = subroot->parse->rtable;

635

638

639

/*

640

* Since we don't yet support LATERAL, it should not be possible for the

641

* sub-query to have requested parameters of this level.

642

*/

643

if (root->plan_params)

644

elog(ERROR, "unexpected outer reference in subquery in FROM");

645

636

646

/* Copy number of output rows from subplan */

637

647

rel->tuples = rel->subplan->plan_rows;

638

648

Older »