~ubuntu-branches/ubuntu/utopic/postgresql-9.4/utopic-security

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Martin Pitt, CVE-2014-8161
  • Date: 2015-02-06 12:31:46 UTC
  • mfrom: (1.1.5) (7.1.2 utopic-proposed)
  • Revision ID: package-import@ubuntu.com-20150206123146-vtmf30jbkm7w16p8
Tags: 9.4.1-0ubuntu0.14.10
* New upstream security/bug fix release (LP: #1418928)
  - Fix buffer overruns in to_char() [CVE-2015-0241]
  - Fix buffer overruns in contrib/pgcrypto [CVE-2015-0243]
  - Fix possible loss of frontend/backend protocol synchronization after an
    error [CVE-2015-0244]
  - Fix information leak via constraint-violation error messages
    [CVE-2014-8161]
  - See release notes for details about other fixes:
    http://www.postgresql.org/about/news/1569/

Show diffs side-by-side

added added

removed removed

Lines of Context:
44
44
 
45
45
CREATE TABLE vaccluster (i INT PRIMARY KEY);
46
46
ALTER TABLE vaccluster CLUSTER ON vaccluster_pkey;
47
 
INSERT INTO vaccluster SELECT * FROM vactst;
48
47
CLUSTER vaccluster;
49
48
 
 
49
CREATE FUNCTION do_analyze() RETURNS VOID VOLATILE LANGUAGE SQL
 
50
        AS 'ANALYZE pg_am';
 
51
CREATE FUNCTION wrap_do_analyze(c INT) RETURNS INT IMMUTABLE LANGUAGE SQL
 
52
        AS 'SELECT $1 FROM do_analyze()';
 
53
CREATE INDEX ON vaccluster(wrap_do_analyze(i));
 
54
INSERT INTO vaccluster VALUES (1), (2);
 
55
ANALYZE vaccluster;
 
56
 
50
57
VACUUM FULL pg_am;
51
58
VACUUM FULL pg_class;
52
59
VACUUM FULL pg_database;