Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4849

Google translator behaves unexpectedly with Double in WHERE clause of SELECT

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Won't Do
    • Minor
    • None
    • 8.12.10.6_3
    • Misc. Connectors
    • None

    Description

      Query like "SELECT DoubleNum FROM SmallA WHERE DoubleNum > 5.0" gives unexpected results for following values in DoubleNum column:

      • value like '15.1' is probably by google spreadsheet interpreted as date (in function row in sheet appears 15.1.2017), SELECT query returns no results
      • value like '150.1': SELECT returns null

      Attachments

        Activity

          People

            Unassigned Unassigned
            lfabriko@redhat.com Lucie Krejcirova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: