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

Port Bug Report: ERROR: RestrictionClauseSelectivity: bad value 2.213087

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: ERROR: RestrictionClauseSelectivity: bad value 2.213087
Date: 1999-03-16 04:10:16
Message-ID: 199903160410.XAA51758@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: Bram Kivenko
Your email address	: bram(at)xspace(dot)com

Category		: runtime: back-end: SQL
Severity		: non-critical

Summary: ERROR:  RestrictionClauseSelectivity: bad value 2.213087

System Configuration
--------------------
  Operating System   : LINUX 2.0.36

  PostgreSQL version : 6.4.2

  Compiler used      : GCC 2.8.1

Hardware:
---------
Linux mulder 2.0.36 #4 Wed Nov 18 10:49:57 EST 1998 i586

 11:11pm  up 5 days, 15:24, 11 users,  load average: 0.33, 0.26, 0.33
115 processes: 114 sleeping, 1 running, 0 zombie, 0 stopped
CPU states:  0.5% user,  3.2% system,  3.6% nice, 96.3% idle
Mem:   62312K av,  59564K used,   2748K free,  58320K shrd,   3744K buff
Swap:  92728K av,    176K used,  92552K free                 20148K cached


Versions of other tools:
------------------------
Gnu make - 3.74
Flex - 2.5.4

--------------------------------------------------------------------------

Problem Description:
--------------------
All but some spurious select queries with comparisons against
text fields return a RestrictionClauseSelectivity error.

src/backend/optimizer/util/plancat.c:
I modified the function "restriction_selectivity"  
to accept values from 0.0 - 3.0, instead 0.0 to 1.0...

This gets rid of the error message, but it probably doesn't
make for a good engine.

--------------------------------------------------------------------------

Test Case:
----------
The query:
SELECT "xx_entryid" FROM "uui_extras" WHERE "News Type" LIKE 'releases';

Fails on the table:
CREATE TABLE "uui_extras" (
        "xx_entryid" int4,
        "Division" text,
        "list in directory" int2,
        "File Types" text,
        "News Type" text);

The table is currently populated with:
INSERT INTO "uui_extras" values (1000,'Corporate+Office',1,'Documentation','releases');
INSERT INTO "uui_extras" values (1002,'Solutions+-+EMEA',NULL,'Information','reports%3Aquarterly+reports');
INSERT INTO "uui_extras" values (1001,'Card+Services+-+US',NULL,'Upgrade','reports%3Aannual+reports');
INSERT INTO "uui_extras" values (1003,'Card+Services+-+Canada',NULL,'Miscellaneous','highlights');
INSERT INTO "uui_extras" values (1004,NULL,NULL,'FAQ','disclosure');



--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


Responses

pgsql-ports by date

Next:From: Bruce MomjianDate: 1999-03-16 04:18:06
Subject: Re: [PORTS] Port Bug Report: ERROR: RestrictionClauseSelectivity: bad value 2.213087
Previous:From: MarkDate: 1999-03-15 21:36:52
Subject: Postgres Stats

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