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
