[jira] [Comment Edited] (IGNITE-4413) .NET: SqlQuery with DateTime arguments does not work

["Ksenia Rybakova (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-4413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15817991#comment-15817991 ] 

Ksenia Rybakova edited comment on IGNITE-4413 at 1/11/17 10:58 AM:
-------------------------------------------------------------------

Verified in 1.8.2 using dotnet examples:
added Date field to Emploee and the following into query example:
{code}
            var qry2 = cache.Query(new SqlQuery(typeof(Employee), "where Date <= ?", System.DateTime.UtcNow));

            foreach (var entry in qry2)
                Console.WriteLine(">>>    " + entry.Value);
{code}


was (Author: krybakova):
Verified in 1.8.2 using dotnet examples:
added Date field to Emploee and the following into example:
{code}
            var qry2 = cache.Query(new SqlQuery(typeof(Employee), "where Date <= ?", System.DateTime.UtcNow));

            foreach (var entry in qry2)
                Console.WriteLine(">>>    " + entry.Value);
{code}

> .NET: SqlQuery with DateTime arguments does not work
> ----------------------------------------------------
>
>                 Key: IGNITE-4413
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4413
>             Project: Ignite
>          Issue Type: Bug
>          Components: platforms
>    Affects Versions: 1.6, 1.7, 1.8
>            Reporter: Pavel Tupitsyn
>              Labels: .NET
>             Fix For: 2.0
>
>
> DateTime arguments are serialized incorrectly when using SqlQuery.
> This is not the case with SqlFieldsQuery and LINQ. See CacheImpl.WriteQueryArgs and QueryBase.WriteQueryArgs.
> To reproduce:
> {code}
> new SqlQuery("where datefrom <= ?", DateTime.UtcNow)
> {code}



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