Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.5(EOL)
-
Not for Release Notes
Description
create table t1 (t1a int, t1b int, t1c int) engine=myisam; |
insert into t1 values (1,1,1),(2,2,2); |
 |
create table t2 (t2a int, t2b int, t2c int) engine=myisam; |
insert into t2 values (1,1,1),(2,2,2),(3,3,3); |
Run normally, this statement
select * from t2 where t2a in |
(
|
select t1a from t1 |
group by (select t1a > t2b) order by t1a |
);
|
produces
t2a t2b t2c
|
1 1 1
|
2 2 2
|
but when run as a prepared statement, we get
t2a t2b t2c
|
1 1 1
|
we also get the same wrong result when run as a procedure.