Advanced SQL after update to v11.53.8 - Output structures validation on true Change
Application Type
Traditional Web
Service Studio Version
11.53.8 (Build 60995)

Hi all,

Seems that the former validation of output structure fields in advanced sql is no longer working after this latest update. 

I've an output structure with 10 fields and only retrieving 8 of them from sql and it is not identified by the True Change.

Is this normal now?

Thanks.

Hi Paulo,

just did a test, I can confirm this observation.

Never was a fan of having to craft a structure to match the output of an SQL widget, but this is a big step backwards.

At best, there is a mismatch in data type, causing a big error the very first time you try to execute, at worst, the mistake goes unnoticed and technically working, but functionally wrong code gets pushed to production.

I have sent a short feedback through service studio about it, but I'm not sure if this is intentional or not...

Dorine

Hope it's intentional!!! :D :D

mvp_badge
MVP

I already reported this to OutSystems.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.