← Back to branch summary

~ubuntu-branches/ubuntu/trusty/postgresql-9.3/trusty-proposed

« back to all changes in this revision

Viewing changes to src/test/regress/expected/with.out

  • Committer: Package Import Robot
  • Author(s): Martin Pitt
  • Date: 2014-07-24 16:13:59 UTC
  • mfrom: (1.1.8)
  • Revision ID: package-import@ubuntu.com-20140724161359-uk325qfv03euxuuh
Tags: 9.3.5-0ubuntu0.14.04.1
https://launchpad.net/bugs/1348176
* New upstream bug fix release: (LP: #1348176)
  - pg_upgrade: Users who upgraded to version 9.3 using pg_upgrade may have
    an issue with transaction information which causes VACUUM to eventually
    fail. These users should run the script provided in the release notes to
    determine if their installation is affected, and then take the remedy
    steps outlined there.
  - Various data integrity and other bug fixes.
  - Secure Unix-domain sockets of temporary postmasters started during make
    check.
    Any local user able to access the socket file could connect as the
    server's bootstrap superuser, then proceed to execute arbitrary code as
    the operating-system user running the test, as we previously noted in
    CVE-2014-0067. This change defends against that risk by placing the
    server's socket in a temporary, mode 0700 subdirectory of /tmp.
  - See release notes for details:
    http://www.postgresql.org/about/news/1534/
* Remove pg_regress patches to support --host=/path, obsolete with above
  upstream changes and not applicable any more.
* Drop tcl8.6 patch, applied upstream.
* Add missing logrotate test dependency.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/regress/expected/with.out
300
300
 
301
301
-- Check reverse listing
302
302
SELECT pg_get_viewdef('vsubdepartment'::regclass);
303
 
                    pg_get_viewdef                     
304
 
-------------------------------------------------------
305
 
  WITH RECURSIVE subdepartment AS (                   +
306
 
                  SELECT department.id,               +
307
 
                     department.parent_department,    +
308
 
                     department.name                  +
309
 
                    FROM department                   +
310
 
                   WHERE (department.name = 'A'::text)+
311
 
         UNION ALL                                    +
312
 
                  SELECT d.id,                        +
313
 
                     d.parent_department,             +
314
 
                     d.name                           +
315
 
                    FROM department d,                +
316
 
                     subdepartment sd                 +
317
 
                   WHERE (d.parent_department = sd.id)+
318
 
         )                                            +
319
 
  SELECT subdepartment.id,                            +
320
 
     subdepartment.parent_department,                 +
321
 
     subdepartment.name                               +
 
303
                pg_get_viewdef                 
 
304
-----------------------------------------------
 
305
  WITH RECURSIVE subdepartment AS (           +
 
306
          SELECT department.id,               +
 
307
             department.parent_department,    +
 
308
             department.name                  +
 
309
            FROM department                   +
 
310
           WHERE (department.name = 'A'::text)+
 
311
         UNION ALL                            +
 
312
          SELECT d.id,                        +
 
313
             d.parent_department,             +
 
314
             d.name                           +
 
315
            FROM department d,                +
 
316
             subdepartment sd                 +
 
317
           WHERE (d.parent_department = sd.id)+
 
318
         )                                    +
 
319
  SELECT subdepartment.id,                    +
 
320
     subdepartment.parent_department,         +
 
321
     subdepartment.name                       +
322
322
    FROM subdepartment;
323
323
(1 row)
324
324
 
325
325
SELECT pg_get_viewdef('vsubdepartment'::regclass, true);
326
 
                   pg_get_viewdef                    
327
 
-----------------------------------------------------
328
 
  WITH RECURSIVE subdepartment AS (                 +
329
 
                  SELECT department.id,             +
330
 
                     department.parent_department,  +
331
 
                     department.name                +
332
 
                    FROM department                 +
333
 
                   WHERE department.name = 'A'::text+
334
 
         UNION ALL                                  +
335
 
                  SELECT d.id,                      +
336
 
                     d.parent_department,           +
337
 
                     d.name                         +
338
 
                    FROM department d,              +
339
 
                     subdepartment sd               +
340
 
                   WHERE d.parent_department = sd.id+
341
 
         )                                          +
342
 
  SELECT subdepartment.id,                          +
343
 
     subdepartment.parent_department,               +
344
 
     subdepartment.name                             +
 
326
               pg_get_viewdef                
 
327
---------------------------------------------
 
328
  WITH RECURSIVE subdepartment AS (         +
 
329
          SELECT department.id,             +
 
330
             department.parent_department,  +
 
331
             department.name                +
 
332
            FROM department                 +
 
333
           WHERE department.name = 'A'::text+
 
334
         UNION ALL                          +
 
335
          SELECT d.id,                      +
 
336
             d.parent_department,           +
 
337
             d.name                         +
 
338
            FROM department d,              +
 
339
             subdepartment sd               +
 
340
           WHERE d.parent_department = sd.id+
 
341
         )                                  +
 
342
  SELECT subdepartment.id,                  +
 
343
     subdepartment.parent_department,       +
 
344
     subdepartment.name                     +
345
345
    FROM subdepartment;
346
346
(1 row)
347
347
 
360
360
 sum    | bigint |           | plain   | 
361
361
View definition:
362
362
 WITH RECURSIVE t(n) AS (
363
 
                 VALUES (1)
 
363
         VALUES (1)
364
364
        UNION ALL
365
 
                 SELECT t_1.n + 1
366
 
                   FROM t t_1
367
 
                  WHERE t_1.n < 100
 
365
         SELECT t_1.n + 1
 
366
           FROM t t_1
 
367
          WHERE t_1.n < 100
368
368
        )
369
369
 SELECT sum(t.n) AS sum
370
370
   FROM t;