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

Excel translator is not able to manage WHERE clause with time value

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7.1, 8.9
    • None
    • None
    • Hide

      I have created source model from Excel file (.xlsx).
      But SQL query with time value in WHERE clause retrns bad result.

      e.g SELECT IntKey, TimeValue FROM Source.SmallA WHERE TimeValue = '21:00:00' return no result but in excel table are several values with time 21:00:00.

      Show
      I have created source model from Excel file (.xlsx). But SQL query with time value in WHERE clause retrns bad result. e.g SELECT IntKey, TimeValue FROM Source.SmallA WHERE TimeValue = '21:00:00' return no result but in excel table are several values with time 21:00:00.

    Description

      Excel translator is not able to manage WHERE clause with time value. When I use time value in WHERE clause (with <, >, =) I get bad result. There is no problem with Timestamp and Date.

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            jdurani Juraj Duráni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: