Alex Volkov created IGNITE-7480: ----------------------------------- Summary: Select for BINARY type field returns 'strange' value. Key: IGNITE-7480 URL: https://issues.apache.org/jira/browse/IGNITE-7480 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.2 Reporter: Alex Volkov
Steps to reproduce: # Connect to grid using console client and dbc:ignite:thin driver. # Run these sql statements: {code:java} CREATE TABLE tmp_table_binary (key_field INT PRIMARY KEY,field1 BINARY); INSERT INTO tmp_table_binary (key_field, field1) values(1, '00ffaa'); INSERT INTO tmp_table_binary (key_field, field1) values(2, 'ffccaa'); SELECT * FROM tmp_table_binary; {code} Here is output from H2: {code:java} SELECT * FROM tmp_table_binary; KEY_FIELD FIELD1 1 00ffaa 2 ffccaa {code} And this one is from grid: {code} 0: jdbc:ignite:thin://127.0.0.1/> CREATE TABLE tmp_table_binary (key_field INT PRIMARY KEY,field1 BINARY); No rows affected (0.155 seconds) 0: jdbc:ignite:thin://127.0.0.1/> INSERT INTO tmp_table_binary (key_field, field1) values(1, '00ffaa'); 1 row affected (0.089 seconds) 0: jdbc:ignite:thin://127.0.0.1/> INSERT INTO tmp_table_binary (key_field, field1) values(2, 'ffccaa'); 1 row affected (0.009 seconds) 0: jdbc:ignite:thin://127.0.0.1/> SELECT * FROM tmp_table_binary; +--------------------------------+--------------------------------+ | KEY_FIELD | FIELD1 | +--------------------------------+--------------------------------+ | 1 | [B@6219232f | | 2 | [B@605514f9 | +--------------------------------+--------------------------------+ 2 rows selected (0.09 seconds) 0: jdbc:ignite:thin://127.0.0.1/> {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)