search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.24k stars 213 forks source link

No dependencies checking of parameter names of External/UDR procedures [CORE6301] #6543

Open firebird-automations opened 4 years ago

firebird-automations commented 4 years ago

Submitted by: Viktor Belzetskiy (viktor_bs)

No check dependence return fields in udr-procedures

example: ----------------------------------------------------------------- CREATE PROCEDURE TEST_UDR_PROC RETURNS ( NUMBER DOUBLE PRECISION) EXTERNAL NAME 'udr_vds!fstrOpenAnyTable' -- any udr-procedure ENGINE UDR;

CREATE PROCEDURE TEST_PROCEDURE RETURNS ( NUMBER DOUBLE PRECISION) AS BEGIN FOR SELECT NUMBER FROM TEST_UDR_PROC INTO :NUMBER DO SUSPEND;

END;

ALTER PROCEDURE TEST_UDR_PROC RETURNS ( NUMBER_2 DOUBLE PRECISION) -- !!! change field name !!! EXTERNAL NAME 'udr_vds!fstrOpenAnyTable' ENGINE UDR;

Successfull. No error !!!

firebird-automations commented 4 years ago
Modified by: Sean Leyne (seanleyne) summary: No check dependence return fields in udr\-procedures =\> No dependencies checking of parameter names of External/UDR procedures