[ 
https://issues.apache.org/jira/browse/IGNITE-19442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17721861#comment-17721861
 ] 

Alexander Belyak commented on IGNITE-19442:
-------------------------------------------

Same with date:
{noformat}
create table test(k TIMESTAMP not null, v INTEGER not null, primary key (k))
insert into test(k, v) values('+4558399-06-20 05:47:19.000000000', 116513)
select * from test{noformat}
returns
{noformat}
K V 
8399-06-20T05:47:19 116513{noformat}
Insert command for such values returns success.

> Data corruption on huge numeric values
> --------------------------------------
>
>                 Key: IGNITE-19442
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19442
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 3.0
>            Reporter: Alexander Belyak
>            Priority: Major
>              Labels: ignite-3
>
> Simple scenario:
> {noformat}
> create table t17 (key numeric primary key, val varchar(3));
> insert into t17 values(1,'1');
> insert into t17 values(9999999999999999999999999999999999999999999999,'1');
> select * from t17;{noformat}
> returns
> {noformat}
> key val
> 8023796054858137599    1
> 1    1
> {noformat}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to