[ 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)