Обсуждение: RestrictionClauseSelectivity

Поиск
Список
Период
Сортировка

RestrictionClauseSelectivity

От
Frank Bax
Дата:
DROP TABLE   Players;
CREATE TABLE Players ( ReqWhen DATETIME );
ALTER TABLE  Players  ADD  ReqCode   TEXT;
ALTER TABLE  Players  ADD  ReqName   TEXT;
ALTER TABLE  Players  ADD  ReqMail   TEXT;
ALTER TABLE  Players  ADD  ReqPlay   TEXT;
ALTER TABLE  Players  ADD  ReqFeed   TEXT;
ALTER TABLE  Players  ADD  ReqPend   CHAR;
SELECT * FROM Players WHERE ReqCode = 'Test';

Always produces the following error message:

ERROR:  RestrictionClauseSelectivity: bad value 2.451276

I'm on 6.4.2 I think.  Whatever was on RedHat 6.0 CD.
How do I confirm version without the install files?

Frank Bax

Re: [SQL] RestrictionClauseSelectivity

От
Bruce Momjian
Дата:
> DROP TABLE   Players;
> CREATE TABLE Players ( ReqWhen DATETIME );
> ALTER TABLE  Players  ADD  ReqCode   TEXT;
> ALTER TABLE  Players  ADD  ReqName   TEXT;
> ALTER TABLE  Players  ADD  ReqMail   TEXT;
> ALTER TABLE  Players  ADD  ReqPlay   TEXT;
> ALTER TABLE  Players  ADD  ReqFeed   TEXT;
> ALTER TABLE  Players  ADD  ReqPend   CHAR;
> SELECT * FROM Players WHERE ReqCode = 'Test';
> 
> Always produces the following error message:
> 
> ERROR:  RestrictionClauseSelectivity: bad value 2.451276
> 
> I'm on 6.4.2 I think.  Whatever was on RedHat 6.0 CD.
> How do I confirm version without the install files?

Known bug.  Upgrade to 6.5.3, or VACUUM ANALYZE the table.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026