Thread: RestrictionClauseSelectivity

RestrictionClauseSelectivity

From
Frank Bax
Date:
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