David Wayne Birdsall created TRAFODION-2840:
-----------------------------------------------
Summary: ORDER BY clause on a view circumvents [first n]
updatability check
Key: TRAFODION-2840
URL: https://issues.apache.org/jira/browse/TRAFODION-2840
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.3-incubating
Environment: All
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
The following script fails:
>>create table t1 (a int not null, b int, primary key (a));
--- SQL operation complete.
>>
>>insert into t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6);
--- 6 row(s) inserted.
>>
>>create view v1 as select [first 5] * from t1 order by a;
--- SQL operation complete.
>>
>>create view v2 as select [first 5] * from t1;
--- SQL operation complete.
>>
>>update v1 set b = 6;
--- 6 row(s) updated.
>> -- should fail; v1 should be non-updatable
>>
>>update v2 set b = 7;
*** ERROR[4028] Table or view TRAFODION.SEABASE.V2 is not updatable.
*** ERROR[8822] The statement was not prepared.
>>-- does fail; v2 is non-updatable (correctly)
>>
It seems the presence of the ORDER BY clause in the view definition circumvents
the [first n] updatability check.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
