[sqlite] sqlite generate strange field name in union

[麦田观望者]

if we have to tables:
create table t1(f1 integer,f2 integer);
create table t2(f1 integer,f2 integer);‍

the fellowing sql generate a result set with a strange field name:  

select t1.f1 from t1 
union 
select t2.f1 from t2 ‍

we expect a column named "f1" but we get "t1.f1" 

but "select t1.f1 from t1 ‍" get a "f1"

is this a bug or by designed?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users