SQL query failing

[pranavk]

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

[shawkins]

> 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.

[shawkins]

Support for this was later added with: [TEIID-3439] Add support for aliases with . - JBoss Issue Tracker