laptop and a wrench

Bogue

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

Dernière publication: October 9, 2017 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue BUG-000085345
EnvoiFebruary 17, 2015
Dernière modificationJune 5, 2024
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée10.1
StatutWill Not Be Addressed

Informations supplémentaires

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.

Étapes pour reproduire

ID de bogue: BUG-000085345

Logiciel:

  • ArcSDE/Enterprise Geodatabase

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Esri Community

Rechercher des informations associées

Training

Rechercher une formation sur ce sujet

ArcGIS Ideas

Explorer des pistes et donner un avis

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement