Re: [Maria-developers] MDEV-8789: * expanding problem

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.