漏洞
Features with null values are ignored or not displayed when using the '<>' (not equal) operator in ArcMap.
| 漏洞 ID 编号 | BUG-000104895 |
|---|---|
| 已提交 | May 3, 2017 |
| 上次修改时间 | June 5, 2024 |
| 适用范围 | ArcGIS for Desktop |
| 找到的版本 | 10.5 |
| 状态 | Known Limit |
附加信息
I tested your case against the numeric "numb" field and a calculated text field "testnumb" and neither returns the null record. Detailed documentation on this can be found here: https://technet.microsoft.com/en-us/library/ms191270(v=sql.105).aspx. Essentially, NULL is not the same as blank, empty, or zero. It is an "unknown". Because it is of "unknown" value, our definition queries and selections will not return the value. To return the selection you desire, the correct query is: SELECT * FROM test1 WHERE numb <>1 OR numb IS NULL.重现步骤
漏洞 ID: BUG-000104895
软件:
- ArcGIS for Desktop
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序