-
Feature Request
-
Resolution: Obsolete
-
Major
-
None
-
None
-
None
-
None
I'm using teiid version 8.11.3
I have a field of type date over mssql 2012, when applying a date function over it, i get directly the error :
org.teiid.jdbc.TeiidSQLException: TEIID31150 The function 'YEAR(testmark.mydate)' is ambiguous. Use schema qualification.
if I change the field type to datetime, the query executes successfully.
Here is the simplified query i'm testing with:
select YEAR("testmark"."mydate") as "testmark_mydate" from "implify_dataModel_at"."implify_data"."implify_red2"."testmark" "testmark" LIMIT 0 , 10