Posted by Dimitri Furman on 02/25/06 03:23

On Feb 24 2006, 06:09 pm, Erland Sommarskog <esquel@sommarskog.se> wrote in
news:Xns9775190B2482Yazorman@127.0.0.1:

> BernsteinVsTheDb (Orr.Bernstein@gmail.com) writes:
>> Hello all,
>>
>> I have a table that contains 100+ rows. I'm trying to run a query that
>> looks like this:
>> SELECT ..., log10(...) as Rank FROM Table
>> and the resultset contains only the first row of results.
>>
>> SELECT ..., log10(...) as Rank FROM Table ORDER BY Rank
>> returns no results at all!
>>
>> If you replace log10 with log, it does the same thing. However, if you
>> replace log10 with abs, it returns exactly what you'd expect, all 100+
>> rows.
>
> Are all the numbers you perform log/log10 on > 0?

Funny thing is, I had this exact issue today while ranking results.
Log10(0) produces a "A domain error occured" warning message in QA and
causes an empty result set to be returned.

--
remove a 9 to reply by email

[Back to original message]