[
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}
insert into test_e011_REAL (key_field, field1_REAL) values (3,
3.4028235E39);{code}
*Expected result:*
Data has been successfully inserted in the table.
The data returned upon respective select query:
{code:java}
'3','Infinity'{code}
*Actual result:*
Data has not been inserted.
The following error is present:
{code:java}
Character I is neither a decimal digit number, decimal point, nor "e" notation
exponential mark.{code}
*Please note that this issue is present only for IG3.*
was:
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.*
> 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}
> insert into test_e011_REAL (key_field, field1_REAL) values (3,
> 3.4028235E39);{code}
>
> *Expected result:*
> Data has been successfully inserted in the table.
> The data returned upon respective select query:
> {code:java}
> '3','Infinity'{code}
>
> *Actual result:*
> Data has not been inserted.
> The following error is present:
> {code:java}
> Character I is neither a decimal digit number, decimal point, nor "e"
> notation exponential mark.{code}
>
> *Please note that this issue is present only for IG3.*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
