question about IFNULL

[petew1970]

We're experiencing random crashes of our application, we're currently suspicious of the IFNULL function.

Old code which used to be:

IF myclass.type_i2 is null OR
myclass.type_i2 = 0 THEN

has been replaced with

IF ifnull(myclass.type_i2,0) = 0 THEN

In this particular case type_i2 is an attribute on a class (obviously), and is smallint and nullable default value is "SYSTEM".

The new IFNULL code, seems to crash the app, replacing the code to how it was restores stability.

Has anything changed with respect to the IFNULL function?

And just for completion exactly what is the default value for "SYSTEM" for a nullable attribute these days?

OR 5.1.0 (int.w32/00)
BUILDNO=5044
PATCHNO=14141

[Bodo]

The "SYSTEM" default value for any number datataype (integer, smallint, float, decimal) is 0 (zero),
no matter if nullable or not.
You should report the problem in a ServiceDesk issue and provide the w4gl.log for the process that crashed.

[petew1970]

issue 154226 raised.