CREATE OR ALTER VIEW and column type (domain) bug
-------------------------------------------------
Key: CORE-4844
URL: http://tracker.firebirdsql.org/browse/CORE-4844
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.4
Reporter: Attila Molnár
Attachments: HIBAS.ZIP
Hi!
running the next command throws error
EXECUTE BLOCK
AS
BEGIN
rdb$set_context('USER_SESSION', 'VIEW_CREATE_USER', 'SYSDBA');
rdb$set_context('USER_SESSION', 'VIEW_CREATE_PASSWORD', 'masterkey');
EXECUTE PROCEDURE fk_minosites_view_create('*');
END
"This operation is not defined for system tables.
unsuccessful metadata update.
cannot delete.
DOMAIN RDB$245643.
there are 2 dependencies.
At procedure 'FK_MINOSITES_VIEW_CREATE' line: 95, col: 1
At procedure 'FK_MINOSITES_VIEW_CREATE' line: 95, col: 1."
Where RDB$245643 domain comes from? If you see the view source you see specific
domain definition, but the view was created with this generated domain.
SELECT *
FROM rdb$relation_fields f
where trim(f.rdb$relation_name) LIKE 'FK_MINOSITES_'
As I see there are two bugs :
#1 : create/alter view not uses the specified domain, but generates a new one
and uses that when null casted to domain.
#2 : alter view should not fail ICO domain change (domain drop)
Thank you!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
