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?
> Just wanted to know/confirm that this issue is not the expected behavior right?
Yes it's currently a know limitation that aliases cannot contain a period character. Anything else is legal when quoted.