-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Improve PowerShell experience for working with databases #11604
Copy link
Copy link
Closed
Labels
Issue-Discussionthe issue may not have a clear classification yet. The issue may generate an RFC or may be reclassifthe issue may not have a clear classification yet. The issue may generate an RFC or may be reclassifIssue-Enhancementthe issue is more of a feature request than a bugthe issue is more of a feature request than a bugResolution-No ActivityIssue has had no activity for 6 months or moreIssue has had no activity for 6 months or more
Metadata
Metadata
Assignees
Labels
Issue-Discussionthe issue may not have a clear classification yet. The issue may generate an RFC or may be reclassifthe issue may not have a clear classification yet. The issue may generate an RFC or may be reclassifIssue-Enhancementthe issue is more of a feature request than a bugthe issue is more of a feature request than a bugResolution-No ActivityIssue has had no activity for 6 months or moreIssue has had no activity for 6 months or more
Summary of the new feature/enhancement
Initially for 7.0, we accepted a change to have [DBNull]::Value treated as $null. The expectation is that this would make it easier for DB users where their content may contain a DBNull and not require them to explicit check that as well as $null. However, this introduced other issues:
#11084
#10980
#10404
(note that we should probably treat NullString and AutomationNull equivalently)
So we had to revert that change before 7.0 GA (note: that change was reverted in rc.2 release branch which will be used for GA release, but kept in the master branch for now). We would still like to investigate whether such a change (or perhaps a different change) makes sense and consider all peripheral impact (so not just
-eq, but-lt, etc... as well as how it works with null coalescing, etc...)