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

[Mark Tawk (JIRA)]

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

Mark Tawk commented on TEIID-4295:
----------------------------------

I tried the case with teiid 9.0.0, now i'm getting a different exception:

Error TEIID30070 The function 'month(DateTest.DateField)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.

here is the query i'm running on mssql:
select month("DateTest"."DateField") as "DateTest_DateField" from  "implify_dataModel_hX"."implify_data"."implify_red2"."DateTest" "DateTest" LIMIT 0 , 10   

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