[teiid-issues] [JBoss JIRA] (TEIID-4295) TEIID31150 when using date function with MSSQL
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jun 24 15:28:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13257015#comment-13257015 ]
Steven Hawkins commented on TEIID-4295:
---------------------------------------
What is the source query that is generated, and does this still occur on later versions?
> 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)
More information about the teiid-issues
mailing list