[teiid-issues] [JBoss JIRA] (TEIID-4605) SqlServer translator - insert/update statements - timestamp is cast to datetime

[Juraj Duráni (JIRA)]

Juraj Duráni created TEIID-4605:
-----------------------------------

             Summary: SqlServer translator - insert/update statements - timestamp is cast to datetime
                 Key: TEIID-4605
                 URL: https://issues.jboss.org/browse/TEIID-4605
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.12.5
            Reporter: Juraj Duráni
            Assignee: Steven Hawkins


For update statements (insert, update), *timestamp* values are cast to *datatime* type. In MSSQL, this type's range start from year 1753 (1753\-01\-01...). However, there is *datetime2* type, which start from 0001\-01\-01.

This default cast to *datetime* prevents user from inserting value before year 1753 even if column in MSSQL is defined as datetime2.

Note: Specifying column option NATIVE_TYPE has no effect on this issue.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)