MySQL Forums
Forum List  »  InnoDB

Re: query works in 5.6 but not working in 5.7
Posted by: Shane Bester
Date: August 07, 2014 09:45AM

Hi,

I tried to simplify the query to see what was wrong.
What I got instead was a crash in 5.7.4.

Latest 5.7.5 is okay, so please wait and check if that works better when released.

Or, can you provide a simple query and table testcase to demonstrate problem?

-----------
drop table if exists t1,t2;
create table t1(a int)engine=innodb;
create table t2(a int)engine=innodb;
insert into t1 values(1),(2),(3);
insert into t2 values(1),(2),(3);
select d.* from
(
select d.a from t2 right join t1 d on 1
union
select d.a from t2 right join t1 d on 1
order by a
) d
where d.a=1
group by d.a;
-------------

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: query works in 5.6 but not working in 5.7
894
August 07, 2014 09:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.