Yes, I reproduced it.
This is a bug related to calculation of a float value within a SQL query.
Right now, I see some workarounds:
1. Calculate the float value in your application code, and put it as an
argument in SqlFieldsQuery.setArgs(), if possible.
2. Use 100 in a separate column. For the query you wrote, SQL doesn't use
the index in the query plan.
Thanks!
On Thu, Nov 18, 2021 at 12:21 PM 18624049226 <18624049...@163.com> wrote:
> No configuration is required, only start with ignite.sh.
>
> full log is attached.
> 在 2021/11/18 17:10, Maksim Timonin 写道:
>
> Hi, I failed to reproduce it. Could you please provide more details? Some
> about nodes configuration, cache configurations, etc.
>
> Also could you please provide a full stack trace of the exception?
>
> Thanks
>
> On Thu, Nov 18, 2021 at 11:50 AM 18624049226 <18624049...@163.com> wrote:
>
>> Hi,
>>
>> The following issue occurred in version 2.11 and not in version 2.10.
>>
>> create table test1(id varchar primary key, flag long);
>>
>> create index index_test1_flag on test1 (flag);
>>
>> insert into test1(id, flag) values('a1', 1);
>>
>> select * from test1 where flag<100*0.5;
>>
>> then ignite crashed.
>>
>> https://issues.apache.org/jira/browse/IGNITE-15943
>>
>>
>>
