SQL to DDlog compiler cannot compile JOINs with aliases with the same name as the original identifier

[amytai]

Suppose you have the following tables:

create table t1(column1 integer, column2 boolean)
create table t2(column1 integer)

The following view fails to compile:

create view v0 as SELECT DISTINCT t1.column1 as new_column 
                from t1 as t1 
                JOIN t2 as alias2 ON t1.column1 = alias2.column1

with the following exception:

com.vmware.ddlog.translator.TranslationException: Column 't1.column1' not in one of the joined relation
t1.column1 line: 1 column: 94