Dontcheff

Oracle’s maths

In Bugs, Oracle database on January 5, 2011 at 21:08

I have seen very strange computational bugs with Oracle, well most fixed already to my knowledge, but here is something that still makes me wonder.

The indeterminate form zero on the power of zero has been discussed for almost 200 years. You can google about it and decide for yourself. Here is what Oracle gives for the expression in 11.2.0.2:

Another interesting issue is about remainders when the divisor is zero. Of course, when you divide say twenty with zero, you cannot even speak about what the remainder is, right? Here is what Oracle has to say:

I still wonder is natural logarithm of zero on the power of zero really zero 🙂

First time I noticed this was in Oracle 7, I tried again yesterday in 11gR2:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: