← 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/int8.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/int8.sql

190

190

SELECT * FROM generate_series('+4567890123456789'::int8, '+4567890123456799'::int8);

191

191

SELECT * FROM generate_series('+4567890123456789'::int8, '+4567890123456799'::int8, 0);

192

192

SELECT * FROM generate_series('+4567890123456789'::int8, '+4567890123456799'::int8, 2);

193

194

-- check sane handling of INT64_MIN overflow cases

195

SELECT (-9223372036854775808)::int8 * (-1)::int8;

196

SELECT (-9223372036854775808)::int8 / (-1)::int8;

197

SELECT (-9223372036854775808)::int8 % (-1)::int8;

198

SELECT (-9223372036854775808)::int8 * (-1)::int4;

199

SELECT (-9223372036854775808)::int8 / (-1)::int4;

200

SELECT (-9223372036854775808)::int8 % (-1)::int4;

201

SELECT (-9223372036854775808)::int8 * (-1)::int2;

202

SELECT (-9223372036854775808)::int8 / (-1)::int2;

203

SELECT (-9223372036854775808)::int8 % (-1)::int2;

Older »