In Azure synapse SQL POOL getting Setting AnsiWarnings to 'OFF' is not supported how to turn it off then

userv6pX 0
Viewed 25

In Azure synapse SQL POOL I am getting Setting AnsiWarnings to 'OFF' is not supported warning message how to turn it off then. While executing my store procedure I am getting "Null value is Eliminated by an Aggregate or Other SET Operation" this error that is why I wanted to turn off so that it can execute for those null values as well.

Any solution Will help Thank you

data-warehouse azure-synapse azure
1 Answers

This

null value is Eliminated by an Aggregate or Other SET Operation

Is not a error, it's only a warning. It doesn't stop the results from being sent to the client.

If a client treats this as an error, that's a bug. You can work around it as mentioned in the other comments.

David Browne - Microsoft0
Related