← 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/test/regress/sql/join.sql

Committer: Package Import Robot
Author(s): Martin Pitt
Date: 2012-12-10 15:53:42 UTC
mfrom: (1.3.9)
Revision ID: package-import@ubuntu.com-20121210155342-3scm68xcxel275jb

Tags: 8.4.15-0ubuntu10.04

https://launchpad.net/bugs/1088393

* New upstream bug fix release: (LP: #1088393)
  - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY"
    Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when
    changing the state of an index's pg_index row. This prevents race
    conditions that could cause concurrent sessions to miss updating
    the target index, thus resulting in corrupt concurrently-created
    indexes.
    Also, fix various other operations to ensure that they ignore
    invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY"
    command. The most important of these is "VACUUM", because an
    auto-vacuum could easily be launched on the table before corrective
    action can be taken to fix or remove the invalid index.
  - See HISTORY/changelog.gz for details about other bug fixes.

files modified:
HISTORY

INSTALL

configure

configure.in

contrib/pageinspect/btreefuncs.c

debian/changelog

doc/bug.template

doc/man.tar.gz

doc/postgres.tar.gz

doc/src/sgml/backup.sgml

doc/src/sgml/docguide.sgml

doc/src/sgml/func.sgml

doc/src/sgml/ref/create_database.sgml

doc/src/sgml/ref/create_index.sgml

doc/src/sgml/ref/create_schema.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/runtime.sgml

src/backend/Makefile

src/backend/access/heap/README.HOT

src/backend/catalog/index.c

src/backend/catalog/pg_shdepend.c

src/backend/commands/cluster.c

src/backend/commands/indexcmds.c

src/backend/commands/tablecmds.c

src/backend/commands/trigger.c

src/backend/commands/vacuum.c

src/backend/commands/vacuumlazy.c

src/backend/executor/execUtils.c

src/backend/executor/nodeSubplan.c

src/backend/libpq/pqcomm.c

src/backend/nodes/outfuncs.c

src/backend/optimizer/path/equivclass.c

src/backend/optimizer/plan/initsplan.c

src/backend/optimizer/util/plancat.c

src/backend/parser/analyze.c

src/backend/parser/parse_relation.c

src/backend/po/de.po

src/backend/po/fr.po

src/backend/po/ru.po

src/backend/utils/adt/datetime.c

src/backend/utils/adt/int.c

src/backend/utils/adt/int8.c

src/backend/utils/adt/rowtypes.c

src/backend/utils/adt/ruleutils.c

src/backend/utils/cache/relcache.c

src/backend/utils/hash/dynahash.c

src/backend/utils/misc/guc.c

src/bin/initdb/initdb.c

src/bin/pg_ctl/pg_ctl.c

src/bin/pg_dump/pg_backup_tar.c

src/bin/pg_dump/po/de.po

src/bin/pg_dump/po/fr.po

src/bin/pg_dump/po/ru.po

src/bin/pg_resetxlog/pg_resetxlog.c

src/bin/psql/po/fr.po

src/bin/psql/po/pt_BR.po

src/bin/psql/po/ru.po

src/bin/psql/psqlscan.c

src/bin/psql/psqlscan.l

src/include/catalog/index.h

src/include/catalog/pg_index.h

src/include/libpq/pqcomm.h

src/include/nodes/parsenodes.h

src/include/nodes/relation.h

src/include/optimizer/planmain.h

src/include/pg_config.h.win32

src/interfaces/ecpg/preproc/variable.c

src/interfaces/libpq/fe-connect.c

src/interfaces/libpq/fe-lobj.c

src/interfaces/libpq/libpq-dist.rc

src/interfaces/libpq/libpq.rc.in

src/interfaces/libpq/po/de.po

src/interfaces/libpq/po/fr.po

src/makefiles/Makefile.aix

src/port/win32ver.rc

src/test/examples/testlo.c

src/test/regress/expected/alter_table.out

src/test/regress/expected/int2.out

src/test/regress/expected/int4.out

src/test/regress/expected/int8-exp-three-digits.out

src/test/regress/expected/int8.out

src/test/regress/expected/join.out

src/test/regress/expected/rules.out

src/test/regress/expected/subselect.out

src/test/regress/pg_regress.c

src/test/regress/sql/alter_table.sql

src/test/regress/sql/int2.sql

src/test/regress/sql/int4.sql

src/test/regress/sql/int8.sql

src/test/regress/sql/join.sql

src/test/regress/sql/rules.sql

src/test/regress/sql/subselect.sql

src/timezone/data/africa

src/timezone/data/asia

src/timezone/data/australasia

src/timezone/data/europe

src/timezone/data/northamerica

src/timezone/data/southamerica

Show diffs side-by-side

added added

removed removed

src/test/regress/sql/join.sql

330

330

-- regression test: check for bug with propagation of implied equality

331

331

-- to outside an IN

332

332

--

333

analyze tenk1; -- ensure we get consistent plans here

334

333

335

select count(*) from tenk1 a where unique1 in

334

336

(select unique1 from tenk1 b join tenk1 c using (unique1)

335

337

where b.unique2 = 42);

637

639

--

638

640

select * from int4_tbl a full join int4_tbl b on true;

639

641

select * from int4_tbl a full join int4_tbl b on false;

642

643

--

644

-- test handling of potential equivalence clauses above outer joins

645

--

646

647

select q1, unique2, thousand, hundred

648

from int8_tbl a left join tenk1 b on q1 = unique2

649

where coalesce(thousand,123) = q1 and q1 = coalesce(hundred,123);

650

651

select f1, unique2, case when unique2 is null then f1 else 0 end

652

from int4_tbl a left join tenk1 b on f1 = unique2

653

where (case when unique2 is null then f1 else 0 end) = 0;

Older »