[DERBY-3950] You should get an error if you try to override a generated column via an INSERT driven by an inner ResultSet

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.1.1
• Component/s: SQL
• Issue & fix info: Patch Available
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 14/Nov/08 21:04
• Updated: 13/Jul/10 19:14
• Resolved: 18/Nov/08 14:17

Description

On DERBY-481 Dag points out the following bug:

drop table t1;
drop table t2;

create table t1( a int, b int generated always as ( -a ) );
create table t2( a int, b int );

insert into t2( a, b ) values ( 1, 100 );

– should fail to compile. instead, it compiles but at run time the generation clause
– overrides the value coming from the select
insert into t1 select * from t2;

– should fail to compile. instead, it compiles but at run time the generation clause
– overrides the value coming from the select
insert into t1 select a, 0 from t2;

– should also fail to compile. instead, it compiles but at run time the generation clause
– overrides the value coming from the list of literals
insert into t1 values( 2, 200 );

select * from t1;

Issue Links

• is part of: DERBY-481 implement SQL generated columns