#4795 (ok 4.5) Query builder: missing joint for the intermediary table

[Anonymous]

Defining a Relation view does join tables by the relations
defined when using the query builder but then you have three
tables like x,y and z that are connected as x->y and y->z and
you only display x and z no join occurs, it should join the
middle table for joining the 2 tables together....

[hatky]

Logged In: YES
user_id=329784

sorry, I forgat to log in before submiting

[Marc Delisle]

Logged In: YES
user_id=210714

The automatic join works if you select also the y table and
if you select one column from it, even if "show" is not
ticked for this y column.
But I agree it would be more automatic if you don't have to
choose the y table.

[Madhura Jayaratne]

With the current master even this does not seem to work. Using sakila database, it generates
SELECT actor.actor_id, film_actor.last_update, film.film_id
FROM film
LEFT JOIN sakila.film_actor ON film.film_id = film_actor.film_id

[Garvin Hicking]

Logged In: YES
user_id=473563

So, should we fill this as an RFE?

[Marc Delisle]

Logged In: YES
user_id=210714

Yes. Done.

[Marc Delisle]

Ticket moved from /p/phpmyadmin/feature-requests/338/

[Madhura Jayaratne]

Related https://sourceforge.net/p/phpmyadmin/bugs/4510/

[Madhura Jayaratne]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/714ab04d5135136e32fc08c19e191eadeeb6e343