Issue Details (XML | Word | Printable)

Key: CORE-5905
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Maxim Kuzmin
Votes: 0
Watchers: 5
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Inconsistencies with PSQL FUNCTION vs UDF

Created: 30/Aug/18 02:05 AM   Updated: 14/Sep/18 06:37 AM
Component/s: None
Affects Version/s: 3.0.0, 3.0.1, 3.0.2, 3.0.3
Fix Version/s: 3.0.4, 4.0 Beta 1

QA Status: Done successfully


 Description  « Hide
In database created UDF "FORMAT_DATE". For test, I create INTERNAL FUNCTION FORMAT_DATE (introduced in FB 3.0):
CREATE FUNCTION FORMAT_DATE
RETURNS INTEGER
AS
BEGIN
    RETURN 1;
END

After this, I can't use UDF - Firebird always use internal function.
Upon attempt drop internal function FORMAT_DATE, I get error:
DROP FUNCTION FORMAT_DATE

This operation is not defined for system tables.
unsuccessful metadata update.
cannot delete.
UDF FORMAT_DATE.
there are 294 dependencies.

And now I can not delete the test function.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes made changes - 30/Aug/18 02:30 AM
Field Original Value New Value
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Adriano dos Santos Fernandes made changes - 12/Sep/18 03:15 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Won't Fix [ 2 ]
Pavel Cisar made changes - 12/Sep/18 04:27 PM
Status Resolved [ 5 ] Closed [ 6 ]
Adriano dos Santos Fernandes made changes - 13/Sep/18 03:23 PM
Summary Mixing INTERNAL FUNCTION and UDF Inconsistencies with PSQL FUNCTION vs UDF
Adriano dos Santos Fernandes made changes - 13/Sep/18 03:23 PM
Resolution Won't Fix [ 2 ]
Status Closed [ 6 ] Reopened [ 4 ]
Adriano dos Santos Fernandes made changes - 13/Sep/18 04:04 PM
Status Reopened [ 4 ] Resolved [ 5 ]
Fix Version/s 4.0 Beta 1 [ 10750 ]
Fix Version/s 3.0.4 [ 10863 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 14/Sep/18 06:36 AM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status No test Done successfully
Pavel Zotov made changes - 14/Sep/18 06:37 AM
Status Resolved [ 5 ] Closed [ 6 ]