[MDEV-3243] LP:607566 - Assert failure triggered by a query with order by and a virtual column in its select list Created: 2010-07-20  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: Major
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug607566.xml    

 Description   

Originally this bug was reported by Philip Stoev in the bug entry #603654. after the fix for bug #603654 had been committed. Though the bug triggers the same assertion failure it differs from the bug originally reported in the bug entry ##603654 .
The new bug can be reproduced with following simple test case:
CREATE TABLE t1 (
a char(255), b char(255), c char(255), d char(255),
v char(255) AS (CONCAT(c,d) ) VIRTUAL
);
INSERT INTO t1(a,b,c,d) VALUES ('w','x','y','z'), ('W','X','Y','Z');
SELECT v FROM t1 ORDER BY CONCAT(a,b);



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 607566

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