漏洞
The NOT LIKE SQL operator for definition queries incorrectly selects null values in ArcGIS Pro when query expression is in the form NOT LIKE %xxxxxx%.
| 漏洞 ID 编号 | BUG-000128794 |
|---|---|
| 已提交 | February 19, 2020 |
| 上次修改时间 | June 13, 2025 |
| 适用范围 | ArcGIS Pro |
| 找到的版本 | 2.5 |
| 操作系统 | Windows OS |
| 操作系统版本 | 10.0 64 Bit |
| 状态 | As Designed |
附加信息
As per standard SQL specifications, NULL values need to be treated separately. Use the following SQL instead: TEXT NOT LIKE '%Test%' OR TEXT IS NULL解决办法
Use the syntax ('Test'). The modulo operator allows all instances of 'Test' to be excluded, including 'Test' as part of the phrase 'NotTest.' The ('Test') syntax will only return 'Test,' which may not be a viable solution for all users.'
重现步骤
漏洞 ID: BUG-000128794
软件:
- ArcGIS Pro
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序