bugreport
============================================================================
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:
---------------------------------------------------------------------