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

Viewing changes to src/backend/utils/adt/selfuncs.c

Committer: Package Import Robot
Author(s): Martin Pitt
Date: 2013-10-09 10:28:08 UTC
mfrom: (1.4.1) (12.1.8 lucid-security)
Revision ID: package-import@ubuntu.com-20131009102808-zrhonpfn94r34fho

Tags: 8.4.18-0ubuntu10.04

New upstream bug fix release (LP: #1237248). No security issues or
critical issues this time; see HISTORY/changelog.gz for details about bug
fixes.

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

files modified:
COPYRIGHT

HISTORY

INSTALL

configure

configure.in

contrib/btree_gist/btree_utils_var.c

contrib/cube/cube.c

contrib/cube/cubeparse.c

contrib/cube/cubeparse.y

contrib/cube/cubescan.c

contrib/cube/cubescan.l

contrib/pg_trgm/expected/pg_trgm.out

contrib/pg_trgm/sql/pg_trgm.sql

contrib/pg_trgm/trgm_op.c

contrib/pgcrypto/expected/pgp-pubkey-decrypt.out

contrib/pgcrypto/pgp-pubkey.c

contrib/pgcrypto/sql/pgp-pubkey-decrypt.sql

contrib/seg/seg.c

contrib/seg/segparse.c

contrib/seg/segparse.y

contrib/seg/segscan.c

contrib/seg/segscan.l

debian/changelog

doc/bug.template

doc/man.tar.gz

doc/postgres.tar.gz

doc/src/sgml/catalogs.sgml

doc/src/sgml/config.sgml

doc/src/sgml/datatype.sgml

doc/src/sgml/docguide.sgml

doc/src/sgml/external-projects.sgml

doc/src/sgml/func.sgml

doc/src/sgml/installation.sgml

doc/src/sgml/keywords.sgml

doc/src/sgml/legal.sgml

doc/src/sgml/libpq.sgml

doc/src/sgml/lobj.sgml

doc/src/sgml/maintenance.sgml

doc/src/sgml/nls.sgml

doc/src/sgml/ref/create_function.sgml

doc/src/sgml/ref/drop_owned.sgml

doc/src/sgml/ref/select.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/xml2.sgml

src/backend/access/gist/gist.c

src/backend/access/gist/gistproc.c

src/backend/access/gist/gistsplit.c

src/backend/access/gist/gistutil.c

src/backend/access/heap/visibilitymap.c

src/backend/access/transam/varsup.c

src/backend/access/transam/xact.c

src/backend/bootstrap/bootparse.c

src/backend/catalog/pg_proc.c

src/backend/catalog/pg_shdepend.c

src/backend/catalog/storage.c

src/backend/commands/dbcommands.c

src/backend/commands/indexcmds.c

src/backend/commands/portalcmds.c

src/backend/commands/vacuum.c

src/backend/commands/vacuumlazy.c

src/backend/executor/nodeHash.c

src/backend/nls.mk

src/backend/optimizer/path/allpaths.c

src/backend/optimizer/plan/planner.c

src/backend/optimizer/util/tlist.c

src/backend/optimizer/util/var.c

src/backend/parser/gram.c

src/backend/parser/gram.h

src/backend/parser/gram.y

src/backend/parser/parse_expr.c

src/backend/parser/parse_relation.c

src/backend/parser/parse_target.c

src/backend/parser/scansup.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/ru.po

src/backend/postmaster/fork_process.c

src/backend/postmaster/pgstat.c

src/backend/regex/regc_color.c

src/backend/regex/regc_nfa.c

src/backend/regex/regcomp.c

src/backend/regex/regexec.c

src/backend/rewrite/rewriteHandler.c

src/backend/storage/file/fd.c

src/backend/storage/large_object/inv_api.c

src/backend/tcop/postgres.c

src/backend/tcop/pquery.c

src/backend/utils/adt/enum.c

src/backend/utils/adt/float.c

src/backend/utils/adt/formatting.c

src/backend/utils/adt/regexp.c

src/backend/utils/adt/ruleutils.c

src/backend/utils/adt/selfuncs.c

src/backend/utils/adt/timestamp.c

src/backend/utils/adt/varlena.c

src/backend/utils/cache/plancache.c

src/backend/utils/hash/dynahash.c

src/backend/utils/sort/tuplesort.c

src/backend/utils/time/tqual.c

src/bin/initdb/po/es.po

src/bin/initdb/po/it.po

src/bin/initdb/po/ru.po

src/bin/pg_config/po/es.po

src/bin/pg_config/po/it.po

src/bin/pg_config/po/pt_BR.po

src/bin/pg_controldata/po/es.po

src/bin/pg_controldata/po/it.po

src/bin/pg_controldata/po/ru.po

src/bin/pg_ctl/po/es.po

src/bin/pg_ctl/po/it.po

src/bin/pg_ctl/po/pt_BR.po

src/bin/pg_ctl/po/ru.po

src/bin/pg_dump/pg_backup_db.c

src/bin/pg_dump/pg_dump.c

src/bin/pg_dump/pg_dumpall.c

src/bin/pg_dump/po/es.po

src/bin/pg_dump/po/it.po

src/bin/pg_dump/po/pt_BR.po

src/bin/pg_dump/po/ru.po

src/bin/pg_resetxlog/po/es.po

src/bin/pg_resetxlog/po/it.po

src/bin/pg_resetxlog/po/ru.po

src/bin/psql/command.c

src/bin/psql/help.c

src/bin/psql/po/de.po

src/bin/psql/po/es.po

src/bin/psql/po/it.po

src/bin/psql/po/pt_BR.po

src/bin/psql/po/ru.po

src/bin/scripts/po/de.po

src/bin/scripts/po/es.po

src/bin/scripts/po/it.po

src/bin/scripts/po/pt_BR.po

src/bin/scripts/po/ru.po

src/include/access/gist.h

src/include/access/gist_private.h

src/include/nodes/parsenodes.h

src/include/optimizer/tlist.h

src/include/pg_config.h.win32

src/include/port.h

src/include/regex/regerrs.h

src/include/regex/regex.h

src/include/regex/regguts.h

src/include/utils/formatting.h

src/interfaces/ecpg/ecpglib/misc.c

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

src/interfaces/ecpg/ecpglib/po/it.po

src/interfaces/ecpg/pgtypeslib/numeric.c

src/interfaces/ecpg/pgtypeslib/timestamp.c

src/interfaces/ecpg/preproc/output.c

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

src/interfaces/ecpg/preproc/po/it.po

src/interfaces/ecpg/preproc/preproc.c

src/interfaces/ecpg/preproc/preproc.h

src/interfaces/ecpg/preproc/preproc.y

src/interfaces/ecpg/test/expected/pgtypeslib-dt_test.c

src/interfaces/ecpg/test/expected/pgtypeslib-dt_test.stderr

src/interfaces/ecpg/test/expected/pgtypeslib-dt_test.stdout

src/interfaces/ecpg/test/pgtypeslib/dt_test.pgc

src/interfaces/libpq/fe-connect.c

src/interfaces/libpq/fe-print.c

src/interfaces/libpq/fe-secure.c

src/interfaces/libpq/libpq-dist.rc

src/interfaces/libpq/libpq.rc.in

src/interfaces/libpq/po/de.po

src/interfaces/libpq/po/es.po

src/interfaces/libpq/po/it.po

src/interfaces/libpq/po/pt_BR.po

src/interfaces/libpq/po/ru.po

src/makefiles/pgxs.mk

src/pl/plperl/plperl.c

src/pl/plperl/po/es.po

src/pl/plperl/po/it.po

src/pl/plpgsql/src/pl_gram.c

src/pl/plpgsql/src/pl_gram.h

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

src/pl/plpgsql/src/po/it.po

src/pl/plpython/po/es.po

src/pl/plpython/po/it.po

src/pl/tcl/po/es.po

src/pl/tcl/po/it.po

src/port/sprompt.c

src/port/win32ver.rc

src/test/regress/expected/guc.out

src/test/regress/expected/rangefuncs.out

src/test/regress/expected/rowtypes.out

src/test/regress/expected/strings.out

src/test/regress/expected/subselect.out

src/test/regress/expected/union.out

src/test/regress/sql/guc.sql

src/test/regress/sql/rangefuncs.sql

src/test/regress/sql/rowtypes.sql

src/test/regress/sql/strings.sql

src/test/regress/sql/subselect.sql

src/test/regress/sql/union.sql

src/timezone/data/africa

src/timezone/data/antarctica

src/timezone/data/asia

src/timezone/data/australasia

src/timezone/data/europe

src/timezone/data/iso3166.tab

src/timezone/data/northamerica

src/timezone/data/southamerica

src/timezone/data/zone.tab

src/timezone/tznames/Africa.txt

src/timezone/tznames/America.txt

src/timezone/tznames/Antarctica.txt

src/timezone/tznames/Asia.txt

src/timezone/tznames/Atlantic.txt

src/timezone/tznames/Australia

src/timezone/tznames/Australia.txt

src/timezone/tznames/Default

src/timezone/tznames/Etc.txt

src/timezone/tznames/Europe.txt

src/timezone/tznames/India

src/timezone/tznames/Indian.txt

src/timezone/tznames/Pacific.txt

src/timezone/tznames/README

src/tools/msvc/Install.pm

src/tools/msvc/Project.pm

Show diffs side-by-side

added added

removed removed

src/backend/utils/adt/selfuncs.c

1430

1431

* No most-common-value info available. Still have null fraction

1432

* information, so use it for IS [NOT] UNKNOWN. Otherwise adjust

1433

* for null fraction and assume an even split for boolean tests.

1433

* for null fraction and assume a 50-50 split of TRUE and FALSE.

1434

1435

switch (booltesttype)

1436

{

1437

case IS_UNKNOWN:

1438

1439

1440

* Use freq_null directly.

1441

1438

/* select only NULL values */

1442

1439

selec = freq_null;

1443

1440

break;

1444

1441

case IS_NOT_UNKNOWN:

1445

1446

1447

* Select not unknown (not null) values. Calculate from

1448

* freq_null.

1449

1442

/* select non-NULL values */

1450

1443

selec = 1.0 - freq_null;

1451

1444

break;

1452

1445

case IS_TRUE:

1453

case IS_NOT_TRUE:

1454

1446

case IS_FALSE:

1455

case IS_NOT_FALSE:

1447

/* Assume we select half of the non-NULL values */

1456

1448

selec = (1.0 - freq_null) / 2.0;

1457

1449

break;

1450

case IS_NOT_TRUE:

1451

case IS_NOT_FALSE:

1452

/* Assume we select NULLs plus half of the non-NULLs */

1453

/* equiv. to freq_null + (1.0 - freq_null) / 2.0 */

1454

selec = (freq_null + 1.0) / 2.0;

1455

break;

1458

1456

default:

1459

1457

elog(ERROR, "unrecognized booltesttype: %d",

1460

1458

(int) booltesttype);

2988

2986

ListCell *l;

2989

2987

2990

2988

2989

* We don't ever want to return an estimate of zero groups, as that tends

2990

* to lead to division-by-zero and other unpleasantness. The input_rows

2991

* estimate is usually already at least 1, but clamp it just in case it

2992

* isn't.

2993

2994

input_rows = clamp_row_est(input_rows);

2995

2996

2991

2997

* If no grouping columns, there's exactly one group. (This can't happen

2992

2998

* for normal cases with GROUP BY or DISTINCT, but it is possible for

2993

2999

* corner cases with set operations.)

Older »