← Back to team overview

maria-developers team mailing list archive

Re: MDEV-8789: * expanding problem

 

On 11.01.2016 20:36, Oleksandr Byelkin wrote:
Hi!

create table t1(a int, b int);
insert into t1 values (1,1),(2,2),(10,10),(20,20);
create table t2(c int, d int);
insert into t2 values (10,1),(20,2);
create database test2;
create table test2.t2(c int, d int);
insert into test2.t2 values (10,1),(20,2);
with tt as (select a,b from t1 where a < 10) select * from t2 as tt, t2;
c    d    c    d
10    1    10    1
20    2    10    1
10    1    20    2
20    2    20    2
drop table t1,t2;
drop databese test2;

I expected columns a,b,c,d and result shoud be different.
oops, sorry my mistake. of course result and columns are correct.


Follow ups

References