Usage of a NATURAL JOIN with a derived table crashes the server [CORE3834] #4176
Submitted by: Daniele Cocca (jmc)
I've found that the following query:
SELECT DISTINCT "Revision", COALESCE("Message", '') AS "LogMessage"
can systematically crash Firebird. I've tried running the server through a debugger on my x64 Linux system and it seems to me like a null pointer dereferencing. Here follows the backtrace:
Program received signal SIGSEGV, Segmentation fault.
I can give the statements used to create the affected tables if needed.
====== Test Details ======
Field 'stageid' does exist in both tables ('tilemaps' and 'logs'), so it CAN be used here w/o alias prefix in WHERE clause.
The text was updated successfully, but these errors were encountered:
Modified by: @pavel-zotov
status: Closed [ 6 ] => Closed [ 6 ]
Test Details: Field 'stageid' does exist in both tables ('tilemaps' and 'logs'), so it CAN be used here w/o alias prefix in WHERE clause.