Assert failure triggered by a query with order by and a virtual column in its select list

Bug #607566 reported by Igor Babaev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
High
Igor Babaev
5.2
Fix Released
Undecided
Unassigned

Bug 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);

Changed in maria:
status: New → Confirmed
importance: Undecided → High
assignee: nobody → Igor Babaev (igorb-seattle)
Changed in maria:
status: Confirmed → Fix Committed
Changed in maria:
milestone: none → 5.2
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.