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

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13257016#comment-13257016 ] 

Steven Hawkins commented on TEIID-4295:
---------------------------------------

In particular TEIID-4124 added a full notion of date type support to the translator.

> 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



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)