Wrong processing a SP parameters with arrays [CORE2516] #2926
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
|
Commented by: Sean Leyne (seanleyne) The lack of support for Arrays in Stored Procedures is a well-known deficiency which has was logged a long time ago. |
Modified by: Sean Leyne (seanleyne)status: Open [ 1 ] => Resolved [ 5 ] resolution: Duplicate [ 3 ] |
|
Commented by: @asfernandes Does the logged entry talk about domains? I've assigned it to me just to reject these cases... |
|
Commented by: @ibprovider Sean, the CORE710 - about new feature, My report about current wrong behaviour of engine. I can create the parameters with array datatypes. But server can't right work with these parameters. So, I think, need or prevent uses of parameters with arrays, or fix this work with arrays :-) |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
|
Commented by: @dyemanov Reopened to let Adriano to resolve this ticket properly (supposedly, to reject array-based domains in procedure parameters?) |
|
Commented by: @asfernandes Yes, rejecting attempts of usage of domains and TYPE OF COLUMN if the domain is an array. |
Modified by: @asfernandesstatus: Reopened [ 4 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC1 [ 10300 ] |
|
Commented by: @pcisar QA test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @ibprovider
Is related to CORE710
Is related to QA405
Server processes the parameters with arrays as simple parameters.
Metadata:
create domain t_smallint_array
as
smallint [0:2];
create procedure sp_smallint_array(x t_smallint_array)
returns (y t_smallint_array)
as
begin
y=x;
suspend;
end;
---
Query
"select * from sp_smallint_array(1)"
works without any errors and returns SMALLINT(1)
Commits: a01096b
The text was updated successfully, but these errors were encountered: