Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Changed UDF metadata not updated until reconnect [CORE2617] #3027

Closed
firebird-automations opened this issue Sep 4, 2009 · 5 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pcisar

Duplicates CORE1973

To reproduce, enter the following commands, and commit each step:

1) Create function with wrong spelling of the entry point

DECLARE EXTERNAL FUNCTION ADDMINUTE
Timestamp, Integer
RETURNS Timestamp
ENTRY_POINT 'ADDMINUTE'
MODULE_NAME 'fbudf';

2) Does not work, naturally

select ADDMINUTE(current_timestamp, 1) from RDB$DATABASE

3)
DROP EXTERNAL FUNCTION ADDMINUTE;

4) Recreate it with the right spelling
DECLARE EXTERNAL FUNCTION ADDMINUTE
Timestamp, Integer
RETURNS Timestamp
ENTRY_POINT 'addMinute'
MODULE_NAME 'fbudf';

5)
select ADDMINUTE(current_timestamp, 1) from RDB$DATABASE

returns:
invalid request BLR at offset 59
function ADDMINUTE is not defined
module name or entrypoint could not be found

it should work now, but it doesn't work until reconnect.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Duplicates CORE1973.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue duplicates CORE1973 [ CORE1973 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant