[teiid-issues] [JBoss JIRA] (TEIID-4295) TEIID31150 when using date function with MSSQL

TEIID31150 when using date function with MSSQL ---------------------------------------------- Key: TEIID-4295 URL: https://issues.jboss.org/browse/TEIID-4295 Project: Teiid Issue Type: Feature Request Reporter: Mark Tawk Assignee: Steven Hawkins 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