Details
-
Bug
-
Resolution: Done
-
Critical
-
fuse-7.x-GA
-
%
-
Not applicable
-
-
- Click on Create a View
- Check contact and todo from PostgresDB database
- After the view is created, go to the edit view
-
Fuse 7.5 Sprint 52 - Bug fix
Description
When I checked more tables in the "Create a view" wizard,
the view contains these tables as cartesian join. However, the second table missing.
Produced DDL:
CREATE VIEW cartesianJoin (first_name, last_name, company, lead_source, create_date, id, task, completed) AS SELECT A.first_name, A.last_name, A.company, A.lead_source, A.create_date, B.id, B.task, B.completed FROM PostgresDB.contact AS A;
Expected DDL:
CREATE VIEW cartesianJoin (first_name, last_name, company, lead_source, create_date, id, task, completed) AS SELECT A.first_name, A.last_name, A.company, A.lead_source, A.create_date, B.id, B.task, B.completed FROM PostgresDB.contact AS A, PostgresDB.todo;
