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