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 Uttsel (Jira)" <ji...@apache.org> on 2020/02/06 09:01:00 UTC

[jira] [Assigned] (IGNITE-12433) Possible to create table with duplicate definition of column

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

Sergey Uttsel reassigned IGNITE-12433:
--------------------------------------

    Assignee: Sergey Uttsel

> Possible to create table with duplicate definition of column
> ------------------------------------------------------------
>
>                 Key: IGNITE-12433
>                 URL: https://issues.apache.org/jira/browse/IGNITE-12433
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.8
>            Reporter: Ilya Kasnacheev
>            Assignee: Sergey Uttsel
>            Priority: Minor
>              Labels: newbie
>
> {code}
> sqlline version 1.3.0
> sqlline> !connect jdbc:ignite:thin://localhost
> Enter username for jdbc:ignite:thin://localhost: 
> Enter password for jdbc:ignite:thin://localhost: 
> 0: jdbc:ignite:thin://localhost> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  NAME VARCHAR(100),  NAME
> . . . . . . . . . . . . . . . .> VARCHAR(100),  AGE INTEGER (64));
> No rows affected (0,229 seconds)
> 0: jdbc:ignite:thin://localhost> select * from person;
> +--------------------------------+--------------------------------+--------------------------------+
> |               ID               |              NAME              |              AGE               |
> +--------------------------------+--------------------------------+--------------------------------+
> +--------------------------------+--------------------------------+--------------------------------+
> No rows selected (0,073 seconds)
> {code}
> This is on master branch. "NAME VARCHAR(100)" twice.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)