[MDEV-3213] LP:1001506 - Crash on a query with GROUP BY and user variables Created: 2012-05-19  Updated: 2015-02-02  Resolved: 2012-10-04

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

Type: Bug Priority: Critical
Reporter: Igor Babaev Assignee: Timour Katchaounov (Inactive)
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1001506.xml    

 Description   

The following simple test case causes a crash of the server in MariaDB 5.2/5.3/5.5:

CREATE TABLE t1(a int);
INSERT INTO t1 VALUES (1), (2);
SELECT DISTINCT @a:=MIN(t1.a) FROM t1, t1 AS t2
GROUP BY @b:=(SELECT COUNT > t2.a);
DROP TABLE t1;

(See also bug #57197 from bugs.mysql.com)

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-05-23 ]

Launchpad bug id: 1001506

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