az kusto script create should return exit code > 0 when there are errors

[karpikpl]

Related command

az kusto script create  --cluster-name $clusterName `
    --database-name $databaseName `
    --name $nameTable `
    --resource-group $resourceGroupName `
    --script-content $qCreateTable `
    --force-update-tag $guid

Is your feature request related to a problem? Please describe.
Pipeline execution is successful when there are errors in running the command.

Describe the solution you'd like
Command should return non-zero code when there are errors.

Describe alternatives you've considered
I'd have to redirect standard error to a file and grep the results for "ERROR" then set error code in the script?

Additional context
Setting "Fail on Standard Error" doesn't help, because warnings are also sent to standard error.
The goal is for the task to fail on errors, but succeed on Warnings.

[yonzhan]

Thank you for opening this issue, we will look into it.