In queries with a cast, that also include other values, value overflow errors are not hinted, but instead throw errors in popups.
Instead, a hint text should be placed on the cell causing the overflow during casting
For instance,
SELECT CAST(LARGE_VALUE AS INT), LARGE_VALUE
FROM VALUE_TABLE;
where LARGE_VALUE is a string representing an integer with potentially more than 10 digits, on the rows where the cast causes an overflow, a popup will appear.
When the cast is placed by itself, the overflowing rows are omitted in the resultset.
In queries with a cast, that also include other values, value overflow errors are not hinted, but instead throw errors in popups.
Instead, a hint text should be placed on the cell causing the overflow during casting
For instance,
where LARGE_VALUE is a string representing an integer with potentially more than 10 digits, on the rows where the cast causes an overflow, a popup will appear.
When the cast is placed by itself, the overflowing rows are omitted in the resultset.