Юзаю 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.

Не бажок ли это?

Ответить