Re: query works in 5.6 but not working in 5.7
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;
-------------
Subject
Views
Written By
Posted
1988
August 01, 2014 08:00PM
895
August 02, 2014 11:49AM
842
August 05, 2014 09:46AM
885
August 05, 2014 05:51PM
956
August 05, 2014 08:17PM
1161
August 06, 2014 11:19AM
891
August 02, 2014 05:54PM
903
August 05, 2014 08:18PM
Re: query works in 5.6 but not working in 5.7
897
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.