Weird error message for EXP(a really big negative number)
when running EXP(1000) you get a complaint about an overflow, which is fine. But it really took me a good plenty of time to understand why I was getting a "Bad argument for ** operator" errors. My SQL contains both powers (**) and exponents EXP(). I tried to replicate the error with the power functions without success. Only much later I noticed than calling EXP(-100000) results in this error. I'm now damping the arguments also for too small numbers (I had it already for the positive case).
The point is that this error message is really distracting, especially as it refers to the totally unrelated (in the view of the user) ** power operator and the reference manuals talk only about cases like 0**0 for that error.
A better error message would be much more similar to the one for EXP(1000).