Issue Details (XML | Word | Printable)

Key: CORE-3517
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Karol Bieniaszewski
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Server crash with built in function LPAD with string as second parameter

Created: 07/Jun/11 07:47 AM   Updated: 16/May/12 12:35 PM
Component/s: Engine
Affects Version/s: 2.1.4
Fix Version/s: 2.1.5

Time Tracking:
Not Specified

Environment: Windows XP, Windows 2003 Server
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
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)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Karol Bieniaszewski added a comment - 07/Jun/11 07:55 AM - edited
this is related to LPAD
i simplify this to

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

Karol Bieniaszewski added a comment - 07/Jun/11 08:00 AM
i change summary info because i found what exactly cause the server crash

Adriano dos Santos Fernandes added a comment - 09/Jun/11 12:42 AM
In 2.1 non-exact-numeric length argument will fall back to describe result string with 32K length.

Karol Bieniaszewski added a comment - 11/Jun/11 07:51 AM
will be this fix available in some snapshot build?