You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Sergey Kozlov (JIRA)" <ji...@apache.org> on 2018/08/02 16:27:00 UTC
[jira] [Updated] (IGNITE-9167) Wrong output for binary column in
SELECT
[ 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)