Hi!
FYI, I fixed this bug, fix will be available in 2.12 version. It will be
released soon.
On Thu, Nov 18, 2021 at 1:27 PM 18624049226 <18624049...@163.com> wrote:
> Hello,
>
> I know how to avoid this issue, I raise this problem because it does not
> exist in version 2.10.
>
> I think the issues related to SQL Engine and numerical calculation are
> relatively more serious, because they may have a wide impact.
> 在 2021/11/18 17:53, Maksim Timonin 写道:
>
> 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
>>>
>>>
>>>
