Issue Details (XML | Word | Printable)

Key: CORE-6333
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Anton Shchyrov
Votes: 0
Watchers: 6
Operations

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

Not checked the availability of the UDF

Created: 15/Jun/20 01:33 PM   Updated: 16/Jun/20 02:08 PM
Component/s: UDF
Affects Version/s: 3.0.5
Fix Version/s: None

Environment: Windows

QA Status: No test


 Description  « Hide
When a new UDF function is created, its presence in the system is not checked

```
SQL> connect localhost:D:\DB\test.fb user 'SYSDBA' password 'masterkey';
Database: localhost:D:\DB\test.fb, User: SYSDBA
SQL> DECLARE EXTERNAL FUNCTION UDF_TEST RETURNS SMALLINT ENTRY_POINT 'AnyPoint' MODULE_NAME 'not_exists.dll';
SQL> COMMIT;
SQL> SELECT UDF_TEST() FROM rdb$database;
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 36
-function UDF_TEST is not defined
-module name or entrypoint could not be found
SQL>
```

Also, no messages are displayed when restoring the database, if the udf dll library is missing

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Anton Shchyrov made changes - 15/Jun/20 01:34 PM
Field Original Value New Value
Description When a new UDF function is created, its presence in the system is not checked

{code}
SQL> connect localhost:D:\DB\test.fb user 'SYSDBA' password 'masterkey';
Database: localhost:D:\DB\test.fb, User: SYSDBA
SQL> DECLARE EXTERNAL FUNCTION UDF_TEST RETURNS SMALLINT ENTRY_POINT 'AnyPoint' MODULE_NAME 'not_exists.dll';
SQL> COMMIT;
SQL> SELECT UDF_TEST() FROM rdb$database;
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 36
-function UDF_TEST is not defined
-module name or entrypoint could not be found
SQL>
{code}

Also, no messages are displayed when restoring the database, if the udf dll library is missing
When a new UDF function is created, its presence in the system is not checked

```
SQL> connect localhost:D:\DB\test.fb user 'SYSDBA' password 'masterkey';
Database: localhost:D:\DB\test.fb, User: SYSDBA
SQL> DECLARE EXTERNAL FUNCTION UDF_TEST RETURNS SMALLINT ENTRY_POINT 'AnyPoint' MODULE_NAME 'not_exists.dll';
SQL> COMMIT;
SQL> SELECT UDF_TEST() FROM rdb$database;
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 36
-function UDF_TEST is not defined
-module name or entrypoint could not be found
SQL>
```

Also, no messages are displayed when restoring the database, if the udf dll library is missing