Issue Details (XML | Word | Printable)

Key: CORE-3991
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Alex Bekhtin
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

"attempted update of read-only column" when trying update editable view without triggers

Created: 21/Nov/12 11:42 AM   Updated: 21/Nov/12 02:19 PM
Component/s: Engine
Affects Version/s: 3.0 Alpha 1
Fix Version/s: None

Time Tracking:
Not Specified

Environment: Firebird-3.0.0.30131-0_x64

Planning Status: Unspecified


 Description  « Hide
CREATE TABLE TEST_TABLE (
    ID INTEGER
);

CREATE OR ALTER VIEW VIEW_TEST_TABLE(
    ID)
AS
select id
from test_table;

insert into view_test_table(ID) values(10);

update view_test_table set ID = 10;

-----------------
This column cannot be updated because it is derived from an SQL function or expression.
attempted update of read-only column.





 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 21/Nov/12 12:58 PM
Duplicates CORE-3986. It should be fixed since build 30138.