Bug
Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.
| Bug ID Number | BUG-000085345 |
|---|---|
| Submitted | February 17, 2015 |
| Last Modified | June 5, 2024 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.1 |
| Status | Will Not Be Addressed |
Additional Information
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.Steps to Reproduce
Bug ID: BUG-000085345
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App