New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Regression: SP "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work [CORE4623] #4938
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: Sean Leyne (seanleyne) Michal, Please clarify, it seems that there are several issues outlined/inter-mixed. 1- Does this work for both v2.5 and v3.0 CREATE DOMAIN "BinaryBlob_ZIP-FIle" AS BLOB SUB_TYPE -200 SEGMENT SIZE 32000; 2- Does this work for both v2.5 and v3.0 CREATE OR ALTER procedure "ATest" ( "InputBlob1" blob sub_type -200 segment size 32000); 3- Does this work for both v2.5 and v3.0 CREATE OR ALTER procedure "ATest" ( "InputBlob2" type of column "ATestTable"."BlobContent"); 4- Does this work for both v2.5 and v3.0 CREATE OR ALTER procedure "ATest" ( "InputBlob3" "BinaryBlob_ZIP-FIle"); 5- Does this work for both v2.5 and v3.0 CREATE OR ALTER TRIGGER "ATestTable_BI0" FOR "ATestTable" ACTIVE BEFORE INSERT POSITION 0 AS
|
Commented by: Sascha Michel (datiscum1) 1- Does this work for both v2.5 and v3.0 CREATE DOMAIN "BinaryBlob_ZIP-FIle" AS BLOB SUB_TYPE -200 SEGMENT SIZE 32000; 2- Does this work for both v2.5 and v3.0 CREATE OR ALTER procedure "ATest" ( "InputBlob1" blob sub_type -200 segment size 32000); 3- Does this work for both v2.5 and v3.0 CREATE OR ALTER procedure "ATest" ( "InputBlob2" type of column "ATestTable"."BlobContent"); 4- Does this work for both v2.5 and v3.0 CREATE OR ALTER procedure "ATest" ( "InputBlob3" "BinaryBlob_ZIP-FIle"); 5- Does this work for both v2.5 and v3.0 CREATE OR ALTER TRIGGER "ATestTable_BI0" FOR "ATestTable" ACTIVE BEFORE INSERT POSITION 0 AS {Do you realize that "BinaryBlob_ZIP-FIle" is not being used as a domain/data type?} |
Modified by: Sean Leyne (seanleyne)summary: Stored procedure variables with blob sub_type < 0 => Regression: SP "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 2 [ 10586 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Done successfully Test Details: NB: according to http://firebirdfaq.org/faq165/ user applications should only use subtypes 0 and 1. |
Submitted by: Sascha Michel (datiscum1)
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.
*/
Commits: 2ba057c FirebirdSQL/fbt-repository@7054727
====== Test Details ======
NB: according to http://firebirdfaq.org/faq165/ user applications should only use subtypes 0 and 1.
Test implemented with negative numbers after discuss with dimitr, starting letter: 20-apr-2015 16:00.
The text was updated successfully, but these errors were encountered: