-
Notifications
You must be signed in to change notification settings - Fork 8.3k
AutomationNull Behaviour #9997
Copy link
Copy link
Closed
Labels
Committee-ReviewedPS-Committee has reviewed this and made a decisionPS-Committee has reviewed this and made a decisionIssue-Questionideally support can be provided via other mechanisms, but sometimes folks do open an issue to get aideally support can be provided via other mechanisms, but sometimes folks do open an issue to get aResolution-AnsweredThe question is answered.The question is answered.
Metadata
Metadata
Assignees
Labels
Committee-ReviewedPS-Committee has reviewed this and made a decisionPS-Committee has reviewed this and made a decisionIssue-Questionideally support can be provided via other mechanisms, but sometimes folks do open an issue to get aideally support can be provided via other mechanisms, but sometimes folks do open an issue to get aResolution-AnsweredThe question is answered.The question is answered.
See the comments in #9794 for the full extent of the existing discussion, starting with #9794 (comment)
AutomationNull.Value is sometimes detectable and distinguishable from $null in certain cases, for example:
@SeeminglyScience mentioned a possible way we could have it be handled more closely like
[dbnull]and[nullstring]are being handled as of #9794, without losing its current function in the pipeline internals, in #9794 (comment):/cc @daxian-dbw @mklement0
I'm personally in favor of Patrick's solution, as it enables the very clear and concise
$item -is [AutomationNull]with few downsides (the biggest downside being potential implementation complications, but in my opinion these are probably worth tackling). Interested to hear any further discussion on this! 💖