You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
set term ^;
create or alter procedure sp_test(x int, y int) returns(z bigint) as
begin
z=x+y;
suspend;
end
^
set term ;^
commit;
set blob all;
set list on;
select replace(replace(rdb$procedure_source,' ','.'), ascii_char(9), '.') sp_src
from rdb$procedures
where rdb$procedure_name = upper('sp_test');
-- produces:
1) on 2.1.7 and 2.5.5:
SP_SRC 0:4
................begin
..................z=x+y;
..................suspend;
................end
2) on 2.0.7 and 3.0:
SP_SRC 0:4
begin
..................z=x+y;
..................suspend;
................end
So, leading whitespaces that were left side of starting 'BEGIN' keyword, are removed in 3.0.
Is it possible to store source code without any distortion ?
The text was updated successfully, but these errors were encountered:
Submitted by: @pavel-zotov
This code:
set term ^;
create or alter procedure sp_test(x int, y int) returns(z bigint) as
begin
z=x+y;
suspend;
end
^
set term ;^
commit;
set blob all;
set list on;
select replace(replace(rdb$procedure_source,' ','.'), ascii_char(9), '.') sp_src
from rdb$procedures
where rdb$procedure_name = upper('sp_test');
-- produces:
1) on 2.1.7 and 2.5.5:
SP_SRC 0:4
................begin
..................z=x+y;
..................suspend;
................end
2) on 2.0.7 and 3.0:
SP_SRC 0:4
begin
..................z=x+y;
..................suspend;
................end
So, leading whitespaces that were left side of starting 'BEGIN' keyword, are removed in 3.0.
Is it possible to store source code without any distortion ?
The text was updated successfully, but these errors were encountered: