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

Sybase implicit Convertion of String value 'yyyy-MM-dd HH:mm' into a Date value Causes mismatches in JDV Date comparison

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Minor
    • 11.2
    • None
    • Query Engine
    • None
    • Compatibility/Configuration, User Experience

    Description

      Sybase implicitly converts a String value 'yyyy-MM-dd HH:mm' into a Date value.
      This format is not standard and this conversion is specific to Sybase.

      As JDBC/Java standard, JDV implicitly converts
      'yyyy-MM-dd HH:mm:ss' into a Timestamp value
      'yyyy-MM-dd' into a Date value
      So JDV does not considered 'yyyy-MM-dd HH:mm' as a Date value and does not proceed to any implicit conversion. 'yyyy-MM-dd HH:mm' remains like a String value which partially matches with Date comparison

      Constraint
      We cannot modify the incoming query

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-asaji Anu Saji
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: