dynamobi/dynamobi — Issue #716: [FRG-156] insert statement: duplicated column name in insert column list not being caught
Author: dynamobi-build
Created: 2011-12-30 03:44:51+00:00
State: open
Labels: FRG, SQL Validator

[reporter="kvu", created="Mon, 26 Jun 2006 19:07:51 -0500 (GMT-05:00)"]
The problem can be reproduced by this query: (n1 is specified twice in insert column list)

create table t1(n1 integer, n2 integer);

insert into t1 (n1,n1) values (1,2);

select * from t1;

the result is:

+-----+-----+

| N1 | N2 |

+-----+-----+

| 2 | |

+-----+-----+

The merge statement also has similar problem.