You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Ilya Kasnacheev (Jira)" <ji...@apache.org> on 2019/12/11 09:56:00 UTC

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

Ilya Kasnacheev created IGNITE-12433:
----------------------------------------

             Summary: 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


{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)