漏洞
Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.
| 漏洞 ID 编号 | BUG-000085345 |
|---|---|
| 已提交 | February 17, 2015 |
| 上次修改时间 | January 28, 2021 |
| 适用范围 | ArcSDE/Enterprise Geodatabase |
| 找到的版本 | 10.1 |
| 状态 | Will Not Be Addressed |
附加信息
This is expected behavior. The LIKE operator is an operator for character strings. If it is used against a numeric field, the data must be converted to a string. Some databases support implicit conversion from numeric to text, some do not. If the data is pulled from a single database, the query validation can be pushed down to the database. In the case of data being pulled from multiple sources, the validation cannot be pushed to the database and client rules are used instead, and character string operators such as LIKE are flagged as invalid by client-side validation. To query character matches like this the data should be stored as text, or the query should be written using >= and <= operators.重现步骤
漏洞 ID: BUG-000085345
软件:
- ArcSDE/Enterprise Geodatabase
从 ArcGIS 专家处获得帮助
下载 Esri 支持应用程序
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈