Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-55

Filter on DOUBLE columns

    XMLWordPrintable

    Details

    • Type: Explanation
    • Status: Published
    • Affects Version/s: EXASolution 4.2.0, EXASolution 5.0
    • Fix Version/s: None
    • Component/s: EXASolution
    • Labels:
    • Symptoms:
      Hide

      Filter on DOUBLE columns returns unexpected results.

      Show
      Filter on DOUBLE columns returns unexpected results.
    • Explanation:
      Hide

      The DOUBLE values you see in EXAplus may differ from the actual database values due to the JDBC double handling and rendering.

      As the DOUBLE data type is only an approximative numeric type, filters on DOUBLE columns may return unexpected results, due to the approximative nature of this data type.

      Show
      The DOUBLE values you see in EXAplus may differ from the actual database values due to the JDBC double handling and rendering. As the DOUBLE data type is only an approximative numeric type, filters on DOUBLE columns may return unexpected results, due to the approximative nature of this data type.
    • Solution:
      Hide

      We recommend to filter only on DECIMAL columns to avoid described problems.

      Show
      We recommend to filter only on DECIMAL columns to avoid described problems.
    • Category 1:
      SQL - Data types

      Attachments

        Activity

          People

          • Assignee:
            CaptainEXA Captain EXASOL
            Reporter:
            CaptainEXA Captain EXASOL
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: