Commented by: Sean Leyne (seanleyne)

Is an error generated if you use SQL92 syntax?

create view view1 as select t1.field1 as t1f1, t2.field1 as t2f1 from t1 JOIN t2 on http://t2.id = http://t1.id;

Commented by: Ann Harrison (awharrison)

You can use this syntax until 2.1 becomes available and Firebird
respects the alias names

created view v1 (t1_f1, t2_f2) as select t1.f1, t2.f1 from t1 join t2 on (t1.f1 = t2.f2);

Commented by: Stephan Bielmann (sbielmann)

I get the same error with:

create view view1 as select t1.field1 as t1f1, t2.field1 as t2f1 from t1 JOIN t2 on http://t2.id = http://t1.id;

however the other one:

created view v1 (t1_f1, t2_f2) as select t1.f1, t2.f1 from t1 join t2 on (t1.f1 = t2.f2);

works fine. Thanks a lot.

Commented by: @pcisar

Fix confirmed for 2.1 Alpha 1. Test added.

Commented by: @pcisar

Reopened to update ticket information.