Issue Details (XML | Word | Printable)

Key: CORE-4422
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Zotov
Votes: 0
Watchers: 3

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

FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause

Created: 08/May/14 09:50 AM   Updated: 23/Sep/15 11:22 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

File Attachments: 1. Zip Archive (11 kB)

QA Status: Done successfully

 Description  « Hide
The following statement:

select 1
from rdb$database
order by row_number()over( PARTITION BY 1)

-- leads FB to crash.
(Statement failed, SQLSTATE = 08006
Error reading data from the connection.)

Stacktrtace is attached.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 12/May/14 07:07 AM
Pavel, please test the bugfix with your real example.

Pavel Zotov added a comment - 12/May/14 05:01 PM
I've checked on ~10 examples, including those which uses user-defined collations. It seems to me that now all OK.