Re: WHERE 1=2 with performance nightmares

Kyle A. Miller wrote:

The Interbase needs a fix. In a simple where condition, like
CustomerId=5, the database knows it needs to search the CustomerId
field looking for the value 5. It should resolve the phrase before
the search begins. It needs to know what to search for before it
actually searches. No?

No; see my other post. The "fix" proposed would not only be
hard-coding for a nonsense query but would probably violate the SQL
standard.

Moreover, the SQL standard already provides a standardized way of
retrieving metadata via system views, and doing a SELECT with an empty
result set is a lousy way of inserting a record, which is only
seriously considered here because of the design of TDataSet.

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt
your DBs! Open Edition users, get 6.0.1.6 from http://mers.com
.

Relevant Pages

  • Re: Heard on the news
    ... My use of "not" makes an English world of difference, ... Both nor and or are Standard after an initial no or not, although or is more frequent today: No running nor shouting is permitted in the corridors. ... Similarly, you must use nor when negating the second of two negative independent clauses: He cannot find anyone now, nor does he expect to find anyone in the future. ... However, when a verb is negated by not or never, and is followed by a negative verb phrase, you can use either or or nor: He will not permit the change or even consider it. ...
    (alt.usage.english)
  • Re: Exchange Server 2003 Standard- Event ID 447 Database Corruptio
    ... So we've decided to bring up another box with Exchange 2003 Standard on it. ... The only Enterprise License I can find includes 25 CALS. ... Information Store First Storage Group: ... the esutil to attempt to resolve the issue. ...
    (microsoft.public.exchange.admin)
  • Re: A neat synthesis of two earlier themes
    ... Leading edge has been a standard ... phrase in aerodynamics for 90 years and migrated into everyday ... English more than 50 years ago. ... it is actually ahead of the cutting-edge; more advanced but but also more ...
    (alt.usage.english)
  • Re: MAINTAINERS: standardize James Bottomleys name
    ... It is standard: I like my initials; which, ... It's not actually required by RFC 2822. ... allowed in phrase because it introduced a parsing difficulty ...
    (Linux-Kernel)
  • Re: Address of an array = address of its 1st element: undecidable question ?
    ... How about using the standard definition? ... to Keith Thompson elsewhere but despite these it is workable. ... context, the main reason I would not cite it is that is does not ... It is not specifically the phrase ...
    (comp.lang.c)