ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexey Kuznetsov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-468) Schema Import utility assigns incorrect java types
Date Wed, 20 Jan 2016 05:59:39 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexey Kuznetsov updated IGNITE-468:
------------------------------------
    Fix Version/s:     (was: 1.6)

> Schema Import utility assigns incorrect java types
> --------------------------------------------------
>
>                 Key: IGNITE-468
>                 URL: https://issues.apache.org/jira/browse/IGNITE-468
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: sprint-2
>         Environment: MySQL DB server
>            Reporter: Sergey Kozlov
>            Assignee: Alexey Kuznetsov
>
> MySQL Db servers allows follow number data types:
> 1. Unsigned numbers:
> {noformat}
> mysql> create table t1 (a1 tinyint unsigned, a2 tinyint signed, b1 smallint unsigned,
b2 smallint signed, c1 mediumint unsigned, c2 mediumint signed,
> d1 int unsigned, d2 int signed, e1 bigint unsigned, e2 bigint signed);
> Query OK, 0 rows affected (0.41 sec)
> {noformat}
> But the utility assigns for unsigned types same type as for signed one, e.g. 
> SmallInt unsigned (0..255) to Java.lang.Byte (-128 ... +127)
> 2.Allow to set for bit columns (limited to 64):
> {noformat}
> mysql> create table t3 (a bit(64));
> Query OK, 0 rows affected (0.49 sec)
> mysql> insert into t3 values(b'0000000001111101010');
> Query OK, 1 row affected (0.09 sec)
> mysql> select bin(a) from t3;
> +------------+
> | bin(a)     |
> +------------+
> | 1111101010 |
> +------------+
> 1 row in set (0.02 sec)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message