Sverre H. Huseby (shh(at)thathost(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
MOD(RANDOM(),1.0) don't work in 7.3.1
Long Description
I just upgraded from 7.2.3 to 7.3.1. Something has changed, as one of my old queries no longer works:
SELECT MOD(RANDOM(),1.0);
ERROR: Function mod(double precision, numeric) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
I was able to work around it by casting RANDOM() to NUMERIC.
Sample Code
No file was uploaded with this report