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