JOIN: stored fields from the joined table

[sanikolaev]

You can't get a stored field from the joined table, e.g. here select * doesn't return surnames (smith, goldman):

MySQL [(none)]> drop table if exists people; drop table if exists surname; create table people(name text, surname_id bigint); create table surname(surname text); insert into people values (1, 'john', 1), (2, 'mary', 1), (3, 'bill', 2),(4, 'matt', 3); insert into surname values(1, 'smith'),(2, 'goldman'); select * from people left join surname on people.surname_id = surname.id;
--------------
drop table if exists people
--------------

Query OK, 0 rows affected (0.012 sec)

--------------
drop table if exists surname
--------------

Query OK, 0 rows affected (0.026 sec)

--------------
create table people(name text, surname_id bigint)
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
create table surname(surname text)
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
insert into people values (1, 'john', 1), (2, 'mary', 1), (3, 'bill', 2),(4, 'matt', 3)
--------------

Query OK, 4 rows affected (0.000 sec)

--------------
insert into surname values(1, 'smith'),(2, 'goldman')
--------------

Query OK, 2 rows affected (0.000 sec)

--------------
select * from people left join surname on people.surname_id = surname.id
--------------

+------+------+------------+------------+
| id   | name | surname_id | surname.id |
+------+------+------------+------------+
|    1 | john |          1 |          1 |
|    2 | mary |          1 |          1 |
|    3 | bill |          2 |          2 |
|    4 | matt |       NULL |          0 |
+------+------+------------+------------+
4 rows in set (0.000 sec)

Calling it explicitly doesn't help:

MySQL [(none)]> select surname.surname from people left join surname on people.surname_id = surname.id;
--------------
select surname.surname from people left join surname on people.surname_id = surname.id
--------------

ERROR 1064 (42000): table people: parse error: unknown attribute 'surname.surname'

The task is to make it possible to select stored fields from the right table.

[glookka]

Done in 8db8be0