Обсуждение: Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250
Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250
От
Unprivileged user
Дата:
============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Jeff MacDonald Your email address : jeff@hub.org Category : runtime: front-end Severity : non-critical Summary: ERROR:RestrictionClauseSelectivity: bad value 164739.656250 System Configuration -------------------- Operating System : Free BSD 3.2 PostgreSQL version : 6.4.2 Compiler used : gcc Hardware: --------- Pentium II 400, 384 MB ram FreeBSD hub.org 3.2-STABLE FreeBSD 3.2-STABLE #0:i386 Versions of other tools: ------------------------ -------------------------------------------------------------------------- Problem Description: -------------------- here's the table schema Table = psql_cds +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | id | int4 not null default nextval ( | 4 | | name | varchar() | 25 | | cds_ordered | int4 | 4 | | cds_sent | int4 | 4 | | mostrecent_sent | float8 | 8 | +----------------------------------+----------------------------------+-------+ jeff=> select * from psql_cds where mostrecent_sent=6.5; ERROR: RestrictionClauseSelectivity: bad value 164739.656250 -------------------------------------------------------------------------- Test Case: ---------- make a table like above, fill in some values, run that select statement.. -------------------------------------------------------------------------- Solution: --------- --------------------------------------------------------------------------
Re: [PORTS] Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250
От
Bruce Momjian
Дата:
> > jeff=> select * from psql_cds where mostrecent_sent=6.5; > ERROR: RestrictionClauseSelectivity: bad value 164739.656250 > Vacuum analyze the table. ALTER TABLE ADD COLUMN has messed things up. Fixed in 6.5. -- 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, Pennsylvania 19026