sort-bug.txt

text/plain

Download

reedstrm=# set enable_seqscan=on;
SET VARIABLE
reedstrm=# select * from float8_tbl order by f1 asc;
          f1           
-----------------------
             -Infinity
 -1.2345678901234e+200
               -1004.3
               -201.34
                -34.84
 -1.2345678901234e-200
                     0
                     0
                201.34
              Infinity
                   NaN
                      
(12 rows)

reedstrm=# select * from float8_tbl order by f1 desc;
          f1           
-----------------------
              Infinity
                201.34
                     0
                     0
 -1.2345678901234e-200
                -34.84
               -201.34
               -1004.3
 -1.2345678901234e+200
             -Infinity
                   NaN
                      
(12 rows)

reedstrm=# drop index f8_idx;
DROP
reedstrm=# create index f8_idx on float8_tbl (f1);
CREATE
reedstrm=# set enable_seqscan=off;
SET VARIABLE
reedstrm=# select * from float8_tbl order by f1 asc;
          f1           
-----------------------
             -Infinity
 -1.2345678901234e+200
               -1004.3
               -201.34
                -34.84
 -1.2345678901234e-200
                     0
                     0
                201.34
              Infinity
                   NaN
                      
(12 rows)

reedstrm=# select * from float8_tbl order by f1 desc;
          f1           
-----------------------
                      
                   NaN
              Infinity
                201.34
                     0
                     0
 -1.2345678901234e-200
                -34.84
               -201.34
               -1004.3
 -1.2345678901234e+200
             -Infinity
(12 rows)

reedstrm=#