laptop and a wrench

Error

Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.

Última publicación: October 9, 2017 ArcSDE/Enterprise Geodatabase
Número de ID del error BUG-000085345
EnviadoFebruary 17, 2015
Última modificaciónApril 2, 2025
Relacionado conArcSDE/Enterprise Geodatabase
Versión encontrada10.1
EstadoWill Not Be Addressed

Información adicional

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.

Pasos para reproducir

ID del error: BUG-000085345

Software:

  • ArcSDE/Enterprise Geodatabase

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Esri Community

Buscar información relacionada

Training

Encontrar formación relacionada con este tema

ArcGIS Ideas

Explorar ideas y aportar opiniones

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga