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

Viewing changes to src/test/regress/sql/subselect.sql

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

SELECT 1 AS zero WHERE 1 IN (SELECT 2);

-- Check grammar's handling of extra parens in assorted contexts

SELECT * FROM (SELECT 1 AS x) ss;

SELECT * FROM ((SELECT 1 AS x)) ss;

(SELECT 2) UNION SELECT 2;

((SELECT 2)) UNION SELECT 2;

SELECT ((SELECT 2) UNION SELECT 2);

SELECT (((SELECT 2)) UNION SELECT 2);

SELECT (SELECT ARRAY[1,2,3])[1];

SELECT ((SELECT ARRAY[1,2,3]))[2];

SELECT (((SELECT ARRAY[1,2,3])))[3];

-- Set up some simple test tables

CREATE TABLE SUBSELECT_TBL (

Older »