Юзаю FB2 RC3.
Есть представление:
CREATE VIEW "InstanceCollections"(
"Id",
"Name",
"Description",
"Instance")
AS
SELECT * FROM "Collections" C
WHERE CURRENT_ROLE = 'NONE' OR C."Instance" IN ('NONE', CURRENT_ROLE)
ORDER BY CAST(SUBSTRING(UPPER("Name") FROM 1 FOR 50) AS VARCHAR(50));
Раньше, когда небыло ORDER BY, оно было автоматически обновляемым, а
после добавления ORDER BY стало вдруг только для чтения. Говорит:
The object of the insert, delete or update statement is a view for which
the requested operation is not permitted.
cannot update read-only view InstanceCollections.
Не бажок ли это?