[
https://issues.jboss.org/browse/TEIID-4295?page=com.atlassian.jira.plugin...
]
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)