[ https://issues.apache.org/jira/browse/IGNITE-9167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Kozlov updated IGNITE-9167: ---------------------------------- Description: 1. Start Ignite node 2. Start sqlline and make table with BINARY column 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} was: 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} > 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 > Priority: Major > > 1. Start Ignite node > 2. Start sqlline and make table with BINARY column 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)