Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Avadhoot Kulkarni
    Query with IN clause with one/more negative values is...
    Topic posted June 26, 2019 by Avadhoot Kulkarni, tagged SOAP 
    22 Views
    Title:
    Query with IN clause with one/more negative values is failing for INTEGER column
    Summary:
    WHERE clause contains mismatched data types in comparison
    Content:
    I am trying to query the following in soap v1.3 and v1.4 and its throwing error message like : WHERE clause contains mismatched data types in comparison
     
    select INTEGERCOL from GTABLE2 where INTEGERCOL in (-5,-15) order by INTEGERCOL
     
    The same query is working fine with soap version 1.2
     
    But the following query is working fine: 
    select INTEGERCOL from GTABLE2 where INTEGERCOL in (5,15) order by INTEGERCOL
     
    The query is failing if I include one/more negative numbers OR a null value in the IN clause.