laptop and a wrench

Erro

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

Última Publicação: October 9, 2017 ArcSDE/Enterprise Geodatabase
Número de ID do Erro BUG-000085345
EnviadoFebruary 17, 2015
Última ModificaçãoJune 5, 2024
Aplica-se àArcSDE/Enterprise Geodatabase
Versão encontrada10.1
StatusWill Not Be Addressed

Informações Adicionais

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.

Etapas para Reproduzir

ID do Erro: BUG-000085345

Software:

  • ArcSDE/Enterprise Geodatabase

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download