Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-11607

Missing second table name in the created view

XMLWordPrintable

    • Fuse 7.5 Sprint 52 - Bug fix

      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;
      

            mdrillin1@redhat.com Mark Drilling (Inactive)
            mkralik@redhat.com Matej Kralik
            Matej Kralik Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: