We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: Alex Bekhtin (afgm)
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.
The text was updated successfully, but these errors were encountered:
Commented by: @dyemanov
Duplicates CORE3986. It should be fixed since build 30138.
Sorry, something went wrong.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Duplicate [ 3 ]
status: Resolved [ 5 ] => Closed [ 6 ]
QA Status: No test
status: Closed [ 6 ] => Closed [ 6 ]
QA Status: No test => Done successfully
No branches or pull requests
Submitted by: Alex Bekhtin (afgm)
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.
The text was updated successfully, but these errors were encountered: