GBAK doesn't restore Views with UDF's [CORE150]

[firebird-automations]

Submitted by: olschimke (olschimke)

SFID: 586397#⁠ Submitted By: olschimke

GBAK isn't be able to restore views like these:

create view "myview" as select F_PADLEFT(NAME) from mytable;

These views get restored, but on selecting data from them, you get an "arithmetic exception, numeric overflow, or string truncation"

[firebird-automations]

Commented by: Alice F. Bird (firebirds)

Date: 2002-07-25 13:19 Sender: helebor Logged In: YES user_id=60469

Try 1) recreating your view with *correct* syntax...and -- before performing gbak -- 2) testing it with actual data - preferably on data where the length of NAME is close to the declared VARCHAR length

then see whether you are still able to reproduce the failure.

Here is the DDL for your view:

create view "myview" (Padded_Name) as select F_PADLEFT(NAME) from mytable;

Defining a column list for a view is *not* optional when you have output columns that are derived from expressions.
Multi-byte character sets can also cause overflow problems for some of these third-party string UDFs...

We get quite unhappy about people using the bug tracker as a user support forum. Please make a point of posting your problems to the ib-support list first, to establish whether you are looking at a bug or an error of your own creation. When you do so, ensure that you provide enough information to help you towards a solution.

[firebird-automations]

Modified by: @dyemanov

status: Closed \[ 6 \] =\> Reopened \[ 4 \] assignee: Dmitry Yemanov \[ dimitr \] SF\_ID: 586397 =\>

[firebird-automations]

Modified by: @dyemanov

status: Reopened \[ 4 \] =\> Resolved \[ 5 \] resolution: Won't Fix \[ 2 \] SF\_ID: 586397 =\>

[firebird-automations]

Modified by: @pcisar

status: Resolved \[ 5 \] =\> Closed \[ 6 \] SF\_ID: 586397 =\>

[firebird-automations]

Modified by: @pcisar

Workflow: jira \[ 10174 \] =\> Firebird \[ 14390 \]