Re: this is a candidate for oracle WTF but radio silence

From: joel garry <joel-garry_at_home.com>
Date: Tue, 9 Apr 2013 15:56:11 -0700 (PDT)
Message-ID: <ef7bdeb7-dba1-4132-bbca-685e964b97d8_at_pt10g2000pbb.googlegroups.com>

On Apr 9, 10:28 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Tue, 09 Apr 2013 17:18:53 +0000, Mladen Gogala wrote:
> > On Tue, 09 Apr 2013 08:48:56 -0700, John Hurley wrote:
>
> >>          AND sku > 'WLD-'

That one is perhaps reasonable, if there are degenerate sku's (prefixes with no numbers attached, I also see that on my systems with "intelligent" overlays of generic vendor keys). But of course it all becomes silly with an exact match predicate. Even so, and including the order by, I've seen it be reasonable in a query generator, just some subset of the generator output is silly. More often I see "and 1=1 and 1=1 and 1=1..."

jg

--
_at_home.com is bogus.
Scaled down Big Data.
http://www.pcworld.com/article/2033659/oracle-rolls-out-new-inmemory-applications-scaleddown-big-data-appliance.html

Received on Wed Apr 10 2013 - 00:56:11 CEST