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

    SQL query failing

    Pranav K Novice

      Hi,

       

      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"

      Error:

      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?


      Thanks,

      Pranav