Parameterized exception: wrong output when number of arguments greater than 7
-----------------------------------------------------------------------------
Key: CORE-4755
URL: http://tracker.firebirdsql.org/browse/CORE-4755
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
Attachments: gen_exc.zip
The following batch generates .sql with declaration of exception that accepts
arbitrary number of arguments (defined as %1 for this batch) and also it adds
EXECUTE BLOCK for testing such exception.
For example, if this batch is called like this:
C:\> gen_exc.bat 3
-- it will create .sql with text:
recreate exception ex_surprised 'OMG... Look what I''ve got:
@1
@2
@3
';
commit;
set term ^;
execute block as
declare v_1 int = 12346;
declare v_2 int = 12347;
declare v_3 int = 12348;
begin
exception ex_surprised using(
v_1
,v_2
,v_3
);
end
^
set term ;^
This .sql will output in STDERR:
Statement failed, SQLSTATE = HY000
exception 12
-EX_SURPRISED
-OMG... Look what I've got:
12346
12347
12348
When I call this batch with argument = 165 the following output will be
produced:
Statement failed, SQLSTATE = HY000
exception 13
-EX_SURPRISED
-OMG... Look what I've got:
12346
12347
12348
12349
12350
12351
12352
@8
@9
123460
123461
. . .
123528
123529
@80
@81
@82
@83
@84
@85
@86
@87
@88
@89
@90
@91
@92
@93
@94
@95
@96
@97
@98
@99
1234600
1234601
. . .
1234643
1234644
1234645
123464...
(see attached file).
So, the questions are:
1) what is the maximum of arguments to parametrized exception ?
2) if no upper limit is defined then how this output can be explained:
2.1) @8, @9 and @80 ... @99 instead of actual values;
2.2) values after '@9' are 10 times larger, values after @99 are 100 times
larger than proper;
2.3) values after 163th argument aren't displayed.
WI-T3.0.0.31794
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
