[Bugs] Advanced SQL - number of selected warning is not correct

Hi there,

# I am using advanced sql and external mysql, and under that widget there is a warning, like this:

"There is a mismatch between the number of column selected and the output structure in SQLxxx",

# When i count the numbers, both are same.

# Then i can trace the root of the cause, that is when one of the column selected has a '.' period, like this:

SyntaxEditor Code Snippet

IFNULL(mycol,-999999999.0) mycol

 # If i remove the period, the warning disappears.

SyntaxEditor Code Snippet

IFNULL(mycol,-999999999) mycol

regards


Solution

Hello,

I'll followup this.

Cheers.

P.S. Just that seems to be a wrong message, but if your columns is actually of integer type, a warning would be valid, as there is really a mismatch in data type (not number)

Solution

Hi Sir,

The column is of type float.

regards

Then It's a false warning. We reported it to OutSystems.

Thank you for bring this up.

Cheers.