← Back to branch summary

~ubuntu-branches/ubuntu/vivid/postgresql-9.4/vivid-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Christoph Berg
  • Date: 2014-11-18 09:49:04 UTC
  • mfrom: (4.1.4 sid)
  • Revision ID: package-import@ubuntu.com-20141118094904-f7f1jhitn5iadkgn
Tags: 9.4~rc1-1
* First 9.4 RC release.
* Update psql call in dump-reload instructions.
* Reenable 010_pg_basebackup.t tests, fixed upstream.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/regress/expected/create_index.out
2754
2754
SELECT thousand, tenthous FROM tenk1
2755
2755
WHERE thousand < 2 AND tenthous IN (1001,3000)
2756
2756
ORDER BY thousand;
 
2757
                      QUERY PLAN                       
 
2758
-------------------------------------------------------
 
2759
 Index Only Scan using tenk1_thous_tenthous on tenk1
 
2760
   Index Cond: (thousand < 2)
 
2761
   Filter: (tenthous = ANY ('{1001,3000}'::integer[]))
 
2762
(3 rows)
 
2763
 
 
2764
SELECT thousand, tenthous FROM tenk1
 
2765
WHERE thousand < 2 AND tenthous IN (1001,3000)
 
2766
ORDER BY thousand;
 
2767
 thousand | tenthous 
 
2768
----------+----------
 
2769
        0 |     3000
 
2770
        1 |     1001
 
2771
(2 rows)
 
2772
 
 
2773
SET enable_indexonlyscan = OFF;
 
2774
explain (costs off)
 
2775
SELECT thousand, tenthous FROM tenk1
 
2776
WHERE thousand < 2 AND tenthous IN (1001,3000)
 
2777
ORDER BY thousand;
2757
2778
                                      QUERY PLAN                                      
2758
2779
--------------------------------------------------------------------------------------
2759
2780
 Sort
2760
2781
   Sort Key: thousand
2761
 
   ->  Index Only Scan using tenk1_thous_tenthous on tenk1
 
2782
   ->  Index Scan using tenk1_thous_tenthous on tenk1
2762
2783
         Index Cond: ((thousand < 2) AND (tenthous = ANY ('{1001,3000}'::integer[])))
2763
2784
(4 rows)
2764
2785
 
2771
2792
        1 |     1001
2772
2793
(2 rows)
2773
2794
 
 
2795
RESET enable_indexscan;
2774
2796
--
2775
2797
-- Check elimination of constant-NULL subexpressions
2776
2798
--