3
 Followers
13
 Likes

Service Studio should show a warning when comparing a variable of a basic data type and the corresponding Identifier data type.

Aggregates & Queries
New

Currently Service Studio shows a warning if you compare a variable of Identifier data type with the corresponding basic data type:

But if it's the reverse situation, comparing a variable of a basic data type and the corresponding Identifier data type, it shows no warning:

This is a general matter of consistency in Service Studio, but this second condition would potentially end up generating the wrong SQL in an Aggregate (using IS NULL instead of = 0.

Created on 29 Nov 2018
Comments (0)
views
193
Followers
3