Issue Details (XML | Word | Printable)

Key: CORE-5943
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Dmitry Yemanov
Reporter: Robson Oliveira
Votes: 0
Watchers: 5
Operations

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

Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list

Created: 16/Oct/18 03:36 PM   Updated: 09/Dec/18 09:52 AM
Component/s: Engine
Affects Version/s: 3.0.3, 3.0.4
Fix Version/s: 4.0 Beta 1, 2.5.9, 3.0.5

Environment:
OS: Windows Server 2012 R2 Standard
Firebird SuperServer

QA Status: Done successfully


 Description  « Hide
When you run any query with the pattern below the service is stopped:

SELECT DISTINCT '0' AS CONSTANT, A.MON$SERVER_PID
FROM MON$ATTACHMENTS A
ORDER BY A.MON$SERVER_PID, A.MON$SERVER_PID

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 16/Oct/18 04:09 PM
I can reproduce this on 3.0.4 (Windows 10, 64 bit); also reproducible on 3.0.3.

Dmitry Yemanov added a comment - 26/Oct/18 07:31 AM
v2.5 is also affected. It doesn' crash but accesses incorrect data in memory and thus theoretically may lead to wrong decisions.