laptop and a wrench

Bug

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

Zuletzt veröffentlicht: October 9, 2017 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer BUG-000085345
EingereichtFebruary 17, 2015
Zuletzt geändertJune 5, 2024
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version10.1
StatusWill Not Be Addressed

Zusätzliche Informationen

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.

Schritte zur Reproduzierung

Bug-ID: BUG-000085345

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln