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
1987
August 01, 2014 08:00PM
893
August 02, 2014 11:49AM
842
August 05, 2014 09:46AM
884
August 05, 2014 05:51PM
955
August 05, 2014 08:17PM
1158
August 06, 2014 11:19AM
890
August 02, 2014 05:54PM
901
August 05, 2014 08:18PM
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.