[
https://issues.apache.org/jira/browse/IGNITE-21856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anatoli Karman updated IGNITE-21856:
------------------------------------
Description:
Insert queries for values with exponent >=39 (e.g.
{*}{{3.4028235E39}}{*}{{{}{}}}) for FLOAT and REAL data type columns results in
an error.
{*}Steps to reproduce{*}:
- send an insert query where a value for REAL or FLOAT column is
*{{3.4028235E39}}*
{code:java}
{code}
{{insert into test_e011_REAL (key_field, field1_REAL) values (3,
3.4028235E39);}}
*Expected result:*
Data has been successfully inserted in the table.
The data returned upon respective select query:
{code:java}
{code}
{{'3','Infinity'}}
*Actual result:*
Data has not been inserted.
The following error is present:
{code:java}
{code}
{{Character I is neither a decimal digit number, decimal point, nor "e"
notation exponential mark.}}
*Please note that this issue is present only for IG3.*
was:
h2.
Insert queries for values with exponent >=39 (e.g. {{{}3.4028235E39{}}}) for
FLOAT and REAL data type columns results in an error.
{*}Steps to reproduce{*}:
# send an insert query where a value for REAL or FLOAT column is
{{3.4028235E39}}
{{insert into test_e011_REAL (key_field, field1_REAL) values (3,
3.4028235E39);}}
*Expected result:*
Data has been successfully inserted in the table.
The data returned upon respective select query:
{{'3','Infinity'}}
*Actual result:*
Data has not been inserted.
The following error is present:
{{Character I is neither a decimal digit number, decimal point, nor "e"
notation exponential mark.}}
*Please note that this issue is present only for IG3.*
> Unable to insert values with exponent values >=39 for FLOAT and REAL
> --------------------------------------------------------------------
>
> Key: IGNITE-21856
> URL: https://issues.apache.org/jira/browse/IGNITE-21856
> Project: Ignite
> Issue Type: Bug
> Reporter: Anatoli Karman
> Priority: Major
>
> Insert queries for values with exponent >=39 (e.g.
> {*}{{3.4028235E39}}{*}{{{}{}}}) for FLOAT and REAL data type columns results
> in an error.
> {*}Steps to reproduce{*}:
>
> - send an insert query where a value for REAL or FLOAT column is
> *{{3.4028235E39}}*
>
> {code:java}
> {code}
> {{insert into test_e011_REAL (key_field, field1_REAL) values (3,
> 3.4028235E39);}}
>
> *Expected result:*
> Data has been successfully inserted in the table.
> The data returned upon respective select query:
>
> {code:java}
> {code}
> {{'3','Infinity'}}
>
> *Actual result:*
> Data has not been inserted.
> The following error is present:
>
> {code:java}
> {code}
> {{Character I is neither a decimal digit number, decimal point, nor "e"
> notation exponential mark.}}
>
>
> *Please note that this issue is present only for IG3.*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
