Issue Details (XML | Word | Printable)

Key: CORE-2182
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0

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

It's impossible to drop an existing UDF which name overlaps with a new built-in function name

Created: 11/Nov/08 02:14 PM   Updated: 22/Aug/16 06:33 AM
Component/s: Engine
Affects Version/s: 2.1.0, 2.1.1
Fix Version/s: 2.1.2, 2.5 Beta 1

QA Status: Covered by another test(s)
Test Details: See core_3963.fbt: one may NOT to create UDF with name <N> if PSQL function does exist with <N>, and vice versa.

 Description  « Hide
This is a common issue with migration to v2.1 and standard UDFs like ABS, ROUND, etc. The usual workaround is to quote the UDF name, i.e. DROP EXTERNAL FUNCTION "ABS", but it doesn't work for Dialect 1 databases.

Actually, the issue is not limited to migration only. Neither you can create an UDF that's expected to override the built-in function with the same name. And it's not about new built-in function names only, the issue is about any new non-reserved keyword introduced in the parser.

This limitation is caused by some UDF related tricks in our parser. But it can be easily improved to handle DDL properly.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.