[IGNITE-9167] Wrong output for binary column in SELECT

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4
• Component/s: sql
• Assignee: Unassigned
• Reporter: Sergey Kozlov
• Created: 02/Aug/18 11:24
• Updated: 23/Sep/18 21:15

Description

1. Start Ignite node
2. Start sqlline and make table with BINARY column then insert and select:

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)

H2 output (for comparison):

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 |
+---+