Stored procedure variables with blob sub_type < 0
--------------------------------------------------
Key: CORE-4623
URL: http://tracker.firebirdsql.org/browse/CORE-4623
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Beta 2
Environment: Linux x64 Firebird-3.0.0.31441
Reporter: Sascha Michel
Priority: Minor
SP variables ( Blob subt_ype < 0 ) as domain or table column reference will
show an error. The same works fine in FB2.5
Undefined name.
CREATE OR ALTER PROCEDURE ATest failed.
Dynamic SQL Error.
SQL error code = -204.
Data type unknown.
Invalid use of CHARACTER SET or COLLATE.
CREATE DOMAIN "BinaryBlob_ZIP-FIle" AS
BLOB SUB_TYPE -200 SEGMENT SIZE 32000;
CREATE TABLE "ATestTable" (
"BlobContent" "BinaryBlob_ZIP-FIle"
);
SET TERM ^ ;
CREATE OR ALTER procedure "ATest" (
"InputBlob1" blob sub_type -200 segment size 32000, <---- This works
"InputBlob2" type of column "ATestTable"."BlobContent", <--- Not work in
FB3 but in 2.5
"InputBlob3" "BinaryBlob_ZIP-FIle") <--- Not work in
FB3 but in 2.5
as
begin
end^
SET TERM ; ^
A Variable from that type in a trigger will work in FB3
e.g.
CREATE OR ALTER TRIGGER "ATestTable_BI0" FOR "ATestTable"
ACTIVE BEFORE INSERT POSITION 0
AS
declare variable "BinaryBlob_ZIP-FIle" integer;
begin
end
^
/*
Undefined name.
CREATE OR ALTER PROCEDURE ATest failed.
Dynamic SQL Error.
SQL error code = -204.
Data type unknown.
Invalid use of CHARACTER SET or COLLATE.
*/
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
