You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@metamodel.apache.org by "Harris Mirza (JIRA)" <ji...@apache.org> on 2016/08/15 09:05:20 UTC

[jira] [Created] (METAMODEL-1112) Where clauses with Date related fields fail on SQL Server

Harris Mirza created METAMODEL-1112:
---------------------------------------

             Summary: Where clauses with Date related fields fail on SQL Server
                 Key: METAMODEL-1112
                 URL: https://issues.apache.org/jira/browse/METAMODEL-1112
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.5.4
         Environment: Running on Java 8 web server using Jersey to provide a REST API. DB is running on SQL Server 2012.
            Reporter: Harris Mirza


Hi, I noticed that when converting a query to SQL and using a condition that includes a date/time field the SQL doesn't run on SQL Server as it adds 'TIMESTAMP' before the value we are comparing. This is invalid syntax and I am not sure why this is added.

Thanks,
Harris Mirza



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)