> Sorry, the bug was another with SELECT FROM PROCEDURE.
Ahh, now it makes sense. It even works as expected on 3.0.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors
Em 12/06/2016 13:08, Jiří Činčura escreveu:
>> And behaves different 3.0, so obvious answer, it was a bug. ;)
>
> On Firebird 3.0 I'm getting:
> Statement failed, SQLSTATE = 42000
> validation error for variable TEST, value "*** null ***"
> -At procedure 'TEST' line: 6, col: 3
>
> Basically the
> And behaves different 3.0, so obvious answer, it was a bug. ;)
On Firebird 3.0 I'm getting:
Statement failed, SQLSTATE = 42000
validation error for variable TEST, value "*** null ***"
-At procedure 'TEST' line: 6, col: 3
Basically the same. So maybe it is still a bug.
--
Mgr. Jiří Činčura
Em 11/06/2016 06:02, Jiří Činčura escreveu:
> Hi *,
>
> let's have this stupid SP:
> create or alter procedure TEST
> returns (
> TEST D_PRIMARY)
> as
> begin
> if (1=0) then
> begin
> suspend;
> end
> end
>
> The D_PRIMARY is BIGINT NN.
>
> Calling it (on Firebird 2.5.5) `execute
Hi *,
let's have this stupid SP:
create or alter procedure TEST
returns (
TEST D_PRIMARY)
as
begin
if (1=0) then
begin
suspend;
end
end
The D_PRIMARY is BIGINT NN.
Calling it (on Firebird 2.5.5) `execute procedure test;` results in:
validation error for variable TEST, value "***