Sergey Kozlov created IGNITE-9167:
-------------------------------------
Summary: Wrong output for binary column in SELECT
Key: IGNITE-9167
URL: https://issues.apache.org/jira/browse/IGNITE-9167
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.4
Reporter: Sergey Kozlov
1. Start Ignite node
2. Start sqlline and make table with BINARY col then insert and select:
{noformat}
sqlline version 1.3.0
0: jdbc:ignite:thin://127.0.0.1/> create table t1 (a int not null, b binary,
primary key(a));
No rows affected (0,127 seconds)
0: jdbc:ignite:thin://127.0.0.1/> insert into t1 (a,b) values (1, NULL);
1 row affected (0,04 seconds)
0: jdbc:ignite:thin://127.0.0.1/> insert into t1 (a,b) values (2, X'00FF');
1 row affected (0 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select * from t1;
+--------------------------------+--------------------------------+
| A | B |
+--------------------------------+--------------------------------+
| 1 | |
| 2 | [B@6276ae34 |
+--------------------------------+--------------------------------+
2 rows selected (0,038 seconds)
{noformat}
H2 output (for comparison):
{noformat}
0: jdbc:h2:mem:test> create table t1 (a int not null, b binary, primary key(a));
No rows affected (0,003 seconds)
0: jdbc:h2:mem:test> insert into t1 (a,b) values (2, X'00FF');
1 row affected (0 seconds)
0: jdbc:h2:mem:test> select b from t1;
+---+
| B |
+---+
| 00ff |
+---+
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
