Bug #17238 select with order by on view dbug asserts
Submitted: 8 Feb 2006 15:01 Modified: 17 Feb 2006 18:51
Reporter: Tomas Ulin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1, 5.0 OS:
Assigned to: Assigned Account CPU Architecture:Any

[8 Feb 2006 15:01] Tomas Ulin
Description:
create table t1 (a int primary key, b int, c int, d int);
create table t2 (a int primary key, b int, c int, d int);
create table t3 (a int primary key, b int, c int, d int);
insert into t1 values (1,2,3,4),(5,6,7,8);
insert into t2 values (11,12,13,14),(15,16,17,18);
insert into t3 values (21,22,23,24),(25,26,27,28);
create view v1 as select t1.a as a, t2.a as b, t3.a as c, t1.b+t2.c+t3.d as d from t1, t2, t3;
select * from v1 order by a,b,c,d;

dbug_asserts in the mysqld

How to repeat:
see above
[8 Feb 2006 15:20] Hartmut Holzgraefe
mysqld: item.cc:5066: virtual bool Item_direct_view_ref::eq(const Item*, bool) const: Assertion `(*ref)->type() == FIELD_ITEM && (item_ref_ref->type() == FIELD_ITEM)' failed.
mysqld got signal 6;

also in 5.0:

mysqld: item.cc:5031: virtual bool Item_direct_view_ref::eq(const Item*, bool) const: Assertion `(*ref)->type() == FIELD_ITEM && (item_ref_ref->type() == FIELD_ITEM)' failed.
mysqld got signal 6;
[17 Feb 2006 18:51] Evgeny Potemkin
Duplicate of bug#17265