Horton

Thread

  1. bugreport

    Yury Don <yura@vpcit.ru> — 2000-01-26T05:44:46Z

    ============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               :Yury Don
Your email address      :yura@vpcit.ru


System Configuration
---------------------
  Architecture (example: Intel Pentium)         :Intel Pentium,
                                                 Intel Pentium II Celeron

  Operating System (example: Linux 2.0.26 ELF)  :Linux 2.0.36 Debian,
                                                 Linux 2.2.12 Debian,

  PostgreSQL version (example: PostgreSQL-6.5.2):PostgreSQL-6.5.2,
                                                 PostgreSQL-6.5.2

  Compiler used (example:  gcc 2.8.0)           :


Please enter a FULL description of your problem:
------------------------------------------------
Query "select ... from ... where ... = ..."
doesn't work properly for the indexed table with field type int4
on certain set of data.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
\connect - postgres
DROP TABLE "tt";
CREATE TABLE "tt" (
        "cc" int4);
COPY "tt" FROM stdin;
-2112563299
-2111287024
-2110307960
....
2146589610
2146589611
2146589612
\.

about 30 000 records totally

mdb=> select cc from tt where cc = -2112563299;
         cc
-----------
-2112563299
(1 row)

mdb=> create index i_tt_cc on tt (cc);
CREATE
mdb=> select cc from tt where cc = -2112563299;
cc
--
(0 rows)

This happens only with large data set where are negative and positive
values.
The full data set is accessible on the http://www.vpcit.ru/tt.gz

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------