Issue Details (XML | Word | Printable)

Key: CORE-296
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Claudio Valderrama C.
Reporter: Claudio Valderrama C.
Votes: 0
Watchers: 0
Operations

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

select fails when udf returning blob

Created: 24/Mar/02 12:00 AM   Updated: 19/Jan/16 05:23 AM
Component/s: None
Affects Version/s: None
Fix Version/s: 1.0.3

SF_ID: 534208
QA Status: No test


 Description  « Hide
SFID: 534208#
Submitted By: robocop

As reported by Ivan Prenosil and other person before:

select udf(<params>) from tbl;

will fail if the udf's return type is a blob. Problem
comes from METD that gives a zero length to blob
fields in UDFs. The correct length for blobs is a
quad, 8 bytes. In turn, METD_get_function() gets zero
because when a udf is defined, ddl.c:put_field()
doesn't send length information for blobs to DYN.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:37 AM
Date: 2002-03-24 03:35
Sender: robocop
Logged In: YES
user_id=62823

Since put_field() is a routine shared by every metadata
definition function, it was much safer to have METD set 8
bytes for udf's params being blobs in the run-time
structure, since this size is fixed and constant.