1 Reply Latest reply on Jan 12, 2016 3:12 PM by Steven Hawkins

    SQL query failing

    Pranav K Novice



      Wanted to point out a scenario where I faced an issue. The following query is fired on a VDB which made atop a JDBC (SQL-Server) based source model. It gives the error as shown below, whereas it works fine when queried over a SQL Server directly.

      SELECT DISTINCT "DBO.CITY"."PostOfficeName" FROM "dbo.City" AS "DBO.CITY"


      TEIID31100 Parsing error: Encountered "FROM \"dbo.City\" AS [*]\"DBO.CITY\"[*]" at line 3, column 20. Invalid alias format: [DBO.CITY]


      I am using Teiid Embedded in my scenario. Just wanted to know/confirm that this issue is not the expected behavior right?