Re: Duplicate column name while creating table

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate column name while creating table

dmagda
It sounds like the implementation specificities of Ignite DML.

SQL folks, how about throwing an exception in case of the duplicate name?

-
Denis


On Thu, Dec 5, 2019 at 9:38 AM DS <[hidden email]>
wrote:

> *I am able to create the table with duplicate column name.*
>
> I was expecting some error saying "cannot create table; duplicate column
> name: NAME"
> Is there some reason that Ignite is not throwing error/exception OR
> is it a bug?
>
> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  NAME VARCHAR(100),  NAME
> VARCHAR(100),  AGE INTEGER (64));
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate column name while creating table

Ilya Kasnacheev
Hello!

I have filed an issue https://issues.apache.org/jira/browse/IGNITE-12433

Regards,
--
Ilya Kasnacheev


ср, 11 дек. 2019 г. в 12:43, Denis Magda <[hidden email]>:

> It sounds like the implementation specificities of Ignite DML.
>
> SQL folks, how about throwing an exception in case of the duplicate name?
>
> -
> Denis
>
>
> On Thu, Dec 5, 2019 at 9:38 AM DS <[hidden email]>
> wrote:
>
>> *I am able to create the table with duplicate column name.*
>>
>> I was expecting some error saying "cannot create table; duplicate column
>> name: NAME"
>> Is there some reason that Ignite is not throwing error/exception OR
>> is it a bug?
>>
>> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  NAME VARCHAR(100),  NAME
>> VARCHAR(100),  AGE INTEGER (64));
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>