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.
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp