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

Properly escape the column references for Excel based data

    Details

    • Workaround Description:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                rareddy Ramesh Reddy
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: