ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@gridgain.com>
Subject Re: Usage of Enums in SQL (Ignite 2.0)
Date Fri, 21 Apr 2017 23:32:43 GMT
Sergi,

That makes total sense. Thanks for adding the feature!

—
Denis

> On Apr 21, 2017, at 12:21 AM, Sergi Vladykin <sergi.vladykin@gmail.com> wrote:
> 
> This ticket is about being able to use enums as INT and VARCHAR literals in
> SQL like this:
> 
> SELECT name FROM person WHERE job = 'BOSS' or job = 2
> 
> Previously you had to always use ? parameters and set enum as a Java object
> there, but this is impossible for any usual SQL console. Now we will be
> able to use constant name or ordinal as a literal.
> 
> Sergi
> 
> 2017-04-21 3:39 GMT+03:00 Denis Magda <dmagda@apache.org>:
> 
>> Alexander P., Sergi,
>> 
>> Could you give me an example on how to use enums in SQL queries [1] from
>> the user standpoint?
>> 
>> It will be ideal if you write a code snippet that demonstrates it. Right
>> after that I’ll add a special section in our SQL Grid documentation.
>> 
>> 
>> [1] https://issues.apache.org/jira/browse/IGNITE-3595 <
>> https://issues.apache.org/jira/browse/IGNITE-3595>
>> 
>> —
>> Denis
>> 
>> 


Mime
View raw message