[
https://issues.apache.org/jira/browse/IGNITE-27739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-27739:
--------------------------------------
Description:
Client's KeyValueView ignores precision specified in a column definition and
allows into insert values with larger precision than it is allowed by column's
type
{noformat}
import java.math.BigDecimal;
import java.util.Map;
import org.apache.ignite.Ignite;
import org.apache.ignite.client.IgniteClient;
import org.apache.ignite.internal.ClusterPerClassIntegrationTest;
import org.apache.ignite.sql.IgniteSql;
import org.apache.ignite.table.KeyValueView;
import org.apache.ignite.table.Table;
import org.apache.ignite.table.Tuple;
import org.apache.ignite.tx.Transaction;
import org.junit.jupiter.api.Test;
public class BigDecimalExample extends ClusterPerClassIntegrationTest {
@Test
public void client() {
try (IgniteClient client =
IgniteClient.builder().addresses("localhost:10800").build()) {
example(client);
}
}
@Test
public void embedded() {
Ignite node = node(0);
example(node);
}
private static void example(Ignite ignite) {
IgniteSql sql = ignite.sql();
sql.executeScript("" +
"DROP TABLE IF EXISTS kv1;" +
"CREATE TABLE kv1 (key INT, val DECIMAL(10,2), PRIMARY KEY
(key) );" +
"DROP TABLE IF EXISTS kv2;" +
"CREATE TABLE kv2 (key INT, str VARCHAR(10), val DECIMAL(10,2),
PRIMARY KEY (key) )"
);
execute(ignite, "kv1");
System.err.println("----");
execute(ignite, "kv2");
}
private static void execute(Ignite client, String tableName) {
Table table = client.tables().table(tableName);
KeyValueView<Tuple, Tuple> view = table.keyValueView();
Tuple key = Tuple.create(Map.of("key", 1));
Tuple value = Tuple.create(Map.of("val", new
BigDecimal("11223344556677889900.123456")));
try {
view.put(null, key, value);
System.err.println("KV PUT OK>");
} catch (Exception e) {
System.err.println("KV PUT ERROR>" + e);
}
System.err.println("KV GET>" + view.get(null, key));
IgniteSql sql = client.sql();
try {
try (var rs = sql.execute((Transaction) null,
"INSERT INTO " + tableName + "(key, val) VALUES(2,
11223344556677889900.123456)")) {
System.err.println("SQL INSERT OK>" + rs.affectedRows());
}
} catch (Exception e) {
System.err.println("SQL INSERT ERROR>" + e);
}
}
}
{noformat}
Output for client:
{noformat}
KV PUT OK>
KV GET>ClientTuple [VAL=11223344556677889900.12]
SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
overflow. A field with precision 10, scale 2 must round to an absolute value
less than 10^8. TraceId:40a67096
----
KV PUT ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1
Failed to serialize row for table PUBLIC.KV2. Numeric field overflow in column
'VAL' TraceId:35ebfc49
KV GET>null
SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
overflow. A field with precision 10, scale 2 must round to an absolute value
less than 10^8. TraceId:ba9bf72e
{noformat}
Output for embedded:
{noformat}
KV PUT ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1
Failed to serialize row for table PUBLIC.KV1. Numeric field overflow in column
'VAL' TraceId:1d10e96a
KV GET>null
SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
overflow. A field with precision 10, scale 2 must round to an absolute value
less than 10^8. TraceId:3d5453d2
----
KV PUT ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1
Failed to serialize row for table PUBLIC.KV2. Numeric field overflow in column
'VAL' TraceId:ea684975
KV GET>null
SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
overflow. A field with precision 10, scale 2 must round to an absolute value
less than 10^8. TraceId:5480b1d3
{noformat}
was:
Client's KeyValueView ignores precision specified in a column definition and
allows into insert values with larger precision than it is allowed by column's
type
{noformat}
import java.math.BigDecimal;
import java.util.Map;
import org.apache.ignite.Ignite;
import org.apache.ignite.client.IgniteClient;
import org.apache.ignite.internal.ClusterPerClassIntegrationTest;
import org.apache.ignite.sql.IgniteSql;
import org.apache.ignite.table.KeyValueView;
import org.apache.ignite.table.Table;
import org.apache.ignite.table.Tuple;
import org.apache.ignite.tx.Transaction;
import org.junit.jupiter.api.Test;
public class BigDecimalExample extends ClusterPerClassIntegrationTest {
@Test
public void client() {
try (IgniteClient client =
IgniteClient.builder().addresses("localhost:10800").build()) {
example(client);
}
}
@Test
public void embedded() {
Ignite node = node(0);
example(node);
}
private static void example(Ignite ignite) {
IgniteSql sql = ignite.sql();
sql.executeScript("" +
"DROP TABLE IF EXISTS kv1;" +
"CREATE TABLE kv1 (key INT, val DECIMAL(10,2), PRIMARY KEY
(key) );" +
"DROP TABLE IF EXISTS kv2;" +
"CREATE TABLE kv2 (key INT, str VARCHAR(10), val DECIMAL(10,2),
PRIMARY KEY (key) )"
);
execute(ignite, "kv1");
System.err.println("----");
execute(ignite, "kv2");
}
private static void execute(Ignite client, String tableName) {
Table table = client.tables().table(tableName);
KeyValueView<Tuple, Tuple> view = table.keyValueView();
Tuple key = Tuple.create(Map.of("key", 1));
Tuple value = Tuple.create(Map.of("val", new
BigDecimal("11223344556677889900.123456")));
try {
view.put(null, key, value);
System.err.println("KV OK>" + view.get(null, key));
} catch (Exception e) {
System.err.println("KV ERROR>" + e);
}
IgniteSql sql = client.sql();
try {
try (var rs = sql.execute((Transaction) null,
"INSERT INTO " + tableName + "(key, val) VALUES(2,
11223344556677889900.123456)")) {
System.err.println("SQL OK>" + rs.affectedRows());
}
} catch (Exception e) {
System.err.println("SQL ERROR>" + e);
}
}
}
{noformat}
Output for client:
{noformat}
KV OK>ClientTuple [VAL=11223344556677889900.12]
SQL ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field overflow.
A field with precision 10, scale 2 must round to an absolute value less than
10^8. TraceId:496ec5d5
----
KV ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1 Failed
to serialize row for table PUBLIC.KV2. Numeric field overflow in column 'VAL'
TraceId:d90ffb3f
SQL ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field overflow.
A field with precision 10, scale 2 must round to an absolute value less than
10^8. TraceId:68bf21f2
{noformat}
Output for embedded:
{noformat}
KV ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1 Failed
to serialize row for table PUBLIC.KV1. Numeric field overflow in column 'VAL'
TraceId:543d0392
SQL ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field overflow.
A field with precision 10, scale 2 must round to an absolute value less than
10^8. TraceId:53cab003
----
KV ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1 Failed
to serialize row for table PUBLIC.KV2. Numeric field overflow in column 'VAL'
TraceId:2b2b486e
SQL ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field overflow.
A field with precision 10, scale 2 must round to an absolute value less than
10^8. TraceId:b83a8cb2
{noformat}
> Thin client. KeyValueView ignores decimal precision
> ---------------------------------------------------
>
> Key: IGNITE-27739
> URL: https://issues.apache.org/jira/browse/IGNITE-27739
> Project: Ignite
> Issue Type: Bug
> Components: thin clients ai3
> Affects Versions: 3.1
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> Client's KeyValueView ignores precision specified in a column definition and
> allows into insert values with larger precision than it is allowed by
> column's type
> {noformat}
> import java.math.BigDecimal;
> import java.util.Map;
> import org.apache.ignite.Ignite;
> import org.apache.ignite.client.IgniteClient;
> import org.apache.ignite.internal.ClusterPerClassIntegrationTest;
> import org.apache.ignite.sql.IgniteSql;
> import org.apache.ignite.table.KeyValueView;
> import org.apache.ignite.table.Table;
> import org.apache.ignite.table.Tuple;
> import org.apache.ignite.tx.Transaction;
> import org.junit.jupiter.api.Test;
> public class BigDecimalExample extends ClusterPerClassIntegrationTest {
> @Test
> public void client() {
> try (IgniteClient client =
> IgniteClient.builder().addresses("localhost:10800").build()) {
> example(client);
> }
> }
> @Test
> public void embedded() {
> Ignite node = node(0);
> example(node);
> }
> private static void example(Ignite ignite) {
> IgniteSql sql = ignite.sql();
>
> sql.executeScript("" +
> "DROP TABLE IF EXISTS kv1;" +
> "CREATE TABLE kv1 (key INT, val DECIMAL(10,2), PRIMARY KEY
> (key) );" +
> "DROP TABLE IF EXISTS kv2;" +
> "CREATE TABLE kv2 (key INT, str VARCHAR(10), val
> DECIMAL(10,2), PRIMARY KEY (key) )"
> );
> execute(ignite, "kv1");
> System.err.println("----");
> execute(ignite, "kv2");
> }
> private static void execute(Ignite client, String tableName) {
> Table table = client.tables().table(tableName);
> KeyValueView<Tuple, Tuple> view = table.keyValueView();
> Tuple key = Tuple.create(Map.of("key", 1));
> Tuple value = Tuple.create(Map.of("val", new
> BigDecimal("11223344556677889900.123456")));
> try {
> view.put(null, key, value);
> System.err.println("KV PUT OK>");
> } catch (Exception e) {
> System.err.println("KV PUT ERROR>" + e);
> }
> System.err.println("KV GET>" + view.get(null, key));
> IgniteSql sql = client.sql();
> try {
> try (var rs = sql.execute((Transaction) null,
> "INSERT INTO " + tableName + "(key, val) VALUES(2,
> 11223344556677889900.123456)")) {
> System.err.println("SQL INSERT OK>" + rs.affectedRows());
> }
> } catch (Exception e) {
> System.err.println("SQL INSERT ERROR>" + e);
> }
> }
> }
> {noformat}
> Output for client:
> {noformat}
> KV PUT OK>
> KV GET>ClientTuple [VAL=11223344556677889900.12]
> SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
> overflow. A field with precision 10, scale 2 must round to an absolute value
> less than 10^8. TraceId:40a67096
> ----
> KV PUT ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1
> Failed to serialize row for table PUBLIC.KV2. Numeric field overflow in
> column 'VAL' TraceId:35ebfc49
> KV GET>null
> SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
> overflow. A field with precision 10, scale 2 must round to an absolute value
> less than 10^8. TraceId:ba9bf72e
> {noformat}
> Output for embedded:
> {noformat}
> KV PUT ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1
> Failed to serialize row for table PUBLIC.KV1. Numeric field overflow in
> column 'VAL' TraceId:1d10e96a
> KV GET>null
> SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
> overflow. A field with precision 10, scale 2 must round to an absolute value
> less than 10^8. TraceId:3d5453d2
> ----
> KV PUT ERROR>org.apache.ignite.lang.MarshallerException: IGN-MARSHALLING-1
> Failed to serialize row for table PUBLIC.KV2. Numeric field overflow in
> column 'VAL' TraceId:ea684975
> KV GET>null
> SQL INSERT ERROR>org.apache.ignite.sql.SqlException: IGN-SQL-7 Numeric field
> overflow. A field with precision 10, scale 2 must round to an absolute value
> less than 10^8. TraceId:5480b1d3
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
