Hi folks,

Firebird 1.5 WI-V6.3.0.4306 Super server on Windows.

I seem to have found an issue with field computed by a UDF. Seems
that I can define the field and use it just fine. Furthermore, a
backup and gfix reveal no problems, but when I attempt to do a restore
I get an error message and the table is not restored

The error message (from IBExpert) is:

IBE: Starting restore. Current time: 8:11:37 AM
gbak: opened file C:\dbdev\UDFComputedBy.FBK
gbak: transportable backup -- data in XDR format
gbak: backup file is compressed
IBE: Unsuccessful execution caused by system error that does not
preclude successful execution of subsequent statements.
action cancelled by trigger (0) to preserve data integrity.
could not find table/procedure for GRANT.

Here is the DDL for a simple test case.

/******************************************************************************/
/**** Generated by IBExpert 2004.10.30 2/7/2005 8:19:45 AM
****/
/******************************************************************************/

SET SQL DIALECT 3;

DECLARE EXTERNAL FUNCTION SUBSTR
CSTRING(80),
SMALLINT,
SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT 'IB_UDF_substr' MODULE_NAME 'ib_udf';

CREATE TABLE NEW_TABLE (
NEW_FIELD VARCHAR(20),
CALCFIELD COMPUTED BY
(substr(new_field,1,1)||substr(new_field,2,1)));

Is this a bug or am I doing something wrong?

thanks

rob