Skip site navigation (1) Skip section navigation (2)

bugreport

From: Yury Don <yura(at)vpcit(dot)ru>
To: bugs(at)postgreSQL(dot)org
Subject: bugreport
Date: 2000-01-26 05:44:46
Message-ID: 7447.000126@vpcit.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               :Yury Don
Your email address      :yura(at)vpcit(dot)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:
---------------------------------------------------------------------



pgsql-bugs by date

Next:From: Yury DonDate: 2000-01-26 05:57:43
Subject: subscribe
Previous:From: Yury DonDate: 2000-01-25 11:52:18
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group