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

Properly escape the column references for Excel based data

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7, 8.0
    • 7.0
    • JDBC Connector
    • None
    • Hide

      You can try building the VDB in the Designer and fix the metadata, so that this issue does not exist

      Show
      You can try building the VDB in the Designer and fix the metadata, so that this issue does not exist

    Description

      Currently when Excel based data is used through Dynamic VDB feature the JDBCODBC Driver reports the metadata in-compatible format thus when the Teiid issues the query to the source it some times sees issues like

      [Prepared Values: [] SQL: SELECT `C:\testing\abcd`.`Sheet1$`.`Name`, `C:\testing\abcd`.`Sheet1$`.`Address`, `C:\testing\abcd`.`Sheet1$`.`Country`, `C:\testing\abcd`.`Sheet1$`.`ZipCode` FROM `C:\testing\abcd`.`Sheet1$`]
      SQLState: -3010

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: