maria-developers team mailing list archive

[Oleksandr Byelkin <sanja@xxxxxxxxxxxxxxxx>]

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.