[
https://issues.apache.org/jira/browse/IGNITE-12433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17038328#comment-17038328
]
Yury Gerzhedovich commented on IGNITE-12433:
--------------------------------------------
[~Sergey Uttsel], thanks. Seems will be better to return your first SQL error
code for the case. It's general error which we found during parsing. Everything
else looks good.
> 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
> Time Spent: 2.5h
> Remaining Estimate: 0h
>
> {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)
