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