Обсуждение: 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 (no need to add data):

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