Assert failure triggered by a query with order by and a virtual column in its select list
Bug #607566 reported by
Igor Babaev
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.