ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vladimir Ozerov <voze...@gridgain.com>
Subject Re: 'Date' and 'Timestamp' types in SQL queries
Date Thu, 11 Feb 2016 09:39:38 GMT
There was some changes in how .NET interoperate w/ Java on binary level. No
changes were made to cache or query logic.
I performed a smoke test in Java and observed that Date field was correctly
mapped to H2 date and then vice versa.

Probably this is a kind of configuration problem.

Vladimir.

On Thu, Feb 11, 2016 at 12:41 AM, Dmitriy Setrakyan <dsetrakyan@apache.org>
wrote:

> I remember seeing some work done for the .NET support to provide better
> precision for time data values. Could it be that SQL now converts
> everything to Timestamp because of that?
>
> D.
>
> On Wed, Feb 10, 2016 at 10:09 AM, Igor Sapego <isapego@gridgain.com>
> wrote:
>
> > Hello,
> >
> > Recently I've been working on implementation of the Date and Timestamp
> > types support for C++ client [1] and I today have faced an issue when I
> was
> > running tests with Date and SqlFieldQuery.
> >
> > Here is the issue. I have class that have field of type 'Date'. I was
> able
> > to create
> > instances of that class and put them in a cache, but when I tried to
> > retrieve
> > these fields with SQL query I've got an exception. After the short debug
> > session
> > I have found that the values that SQL queries return are of type
> > 'Timestamp'.
> >
> > So now I'm wonder, is it an expected behavior? Because to me it looks
> like
> > something that may be very confusing for a user. User knows that object's
> > field
> > is of type 'Date' but when they try to call GetNext<Date> on query row
> they
> > get an
> > exception.
> >
> > I have also tested simple caches with Date where Date is a value and
> these
> > tests
> > work just fine with 'Date' returned as a result of Cache#Get() requests.
> >
> > [1] - IGNITE-2222: CPP: Implement Date and Timestamp data types support
> for
> > binary protocol. <https://issues.apache.org/jira/browse/IGNITE-2222>
> > Best Regards,
> > Igor
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message