0 Replies Latest reply: Jan 17, 2013 12:35 PM by Sumant RSS

    Column Type double and number length 13 to 15 digits - error while query

    Sumant
      Hi,

      I have custom rowsource with field type Double which has number length 13 to 15 digits.
      Table has data type Number(24,8).

      when I query with field in condition it throws error, however when I do Select * from Rowsource_Name it returns all the rows.
      select * from Rowsource_Name where column_name=1212181609184
      
           at com.interlacesystems.iquery.rsql.RSQLParser.parseStatement(Unknown Source)
           ... 58 more
      Caused by: java.lang.NumberFormatException: For input string: "1212181609184"
           at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
           at java.lang.Integer.parseInt(Integer.java:461)
           at java.lang.Integer.parseInt(Integer.java:499)
           at com.interlacesystems.iquery.rsql.RSQLParser.get_number(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.value_object(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.binary_operation_right(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.operation(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.search_term4(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.search_term5(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.search_expression(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.where_clause(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.where_clause_opt(Unknown Source)
           at com.interlacesystems.iquery.rsql.RSQLParser.select_statement(Unknown Source)
           ... 59 more
      Thanks,
      Sumant