[MDEV-5647] Server crashes during join on group-by subquery Created: 2014-02-11  Updated: 2014-02-11  Resolved: 2014-02-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.35
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Cary Converse Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Windows 7 64-bit

Issue Links:
Duplicate
duplicates MDEV-5617 mysqld crashes when running a query w... Closed

 Description   

With ONLY_FULL_GROUP_BY in sql mode, the following query will cause the server to crash. Nothing is written to error log.

table definitions:
create table test1 (a int unsigned not null);
create table test2 (b int unsigned not null);

server crash:
select * from test1 inner join (
select * from test2 group by b) as test2alias
on (test1.a = test2alias.b);

 Comments   
Comment by Elena Stepanova [ 2014-02-11 ]

Thank you for reporting.

This is a duplicate of MDEV-5617. It has the same stack trace and same conditions, started happening with the same revision, and nearly identical test case can be found in this comment to MDEV-5617.

Generated at Thu Feb 08 07:05:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.