Server crash with built in function LPAD with string as second parameter [CORE3517]

[firebird-automations]

Submitted by: @livius2

Is related to QA459

i simplify query for system tables only
and test on FB2.1.4.408 and on recent snapshot FB2.1.5.18427
after run this query server crash

SELECT LPAD(SUBSTRING(R.RDB$CHARACTER_SET_NAME FROM 1 FOR POSITION('.', R.RDB$CHARACTER_SET_NAME)-1), '0', 3)
FROM
RDB$DATABASE R

in firebird.log
PROGRAMISTAKB (Client) Tue Jun 07 09:22:14 2011
"C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe": terminated abnormally (4294967295)

Commits: 80584e7

[firebird-automations]

Commented by: @livius2

this is related to LPAD
i simplify this to

select LPAD('abc', '0', 3) FROM RDB$DATABASE
and server crash

[firebird-automations]

Commented by: @livius2

i change summary info because i found what exactly cause the server crash

[firebird-automations]

Modified by: @livius2

summary: Server crash with built in function combination => Server crash with built in function LPAD with string as second parameter

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: @asfernandes

In 2.1 non-exact-numeric length argument will fall back to describe result string with 32K length.

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1.5 [ 10420 ]

[firebird-automations]

Commented by: @livius2

will be this fix available in some snapshot build?

[firebird-automations]

Modified by: @dyemanov

Version: 2.1.5 [ 10420 ] =>

[firebird-automations]

Modified by: @pmakowski

Link: This issue is related to QA459 [ QA459 ]

[firebird-automations]

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Done successfully