This repository was archived by the owner on Jan 28, 2021. It is now read-only.
This repository was archived by the owner on Jan 28, 2021. It is now read-only.
[Tableau]: GROUP BY X with alias (as columnd name) and INNER JOIN #535
Closed
Description
Add support for this kind of queries:
SELECT SUBSTRING(`repositories`.`repository_id`, 1, 1024) AS `repository_id`
FROM `repositories`
INNER JOIN `commits` ON (SUBSTRING(`repositories`.`repository_id`, 1, 1024) = SUBSTRING(`commits`.`repository_id`, 1, 1024))
INNER JOIN `files` ON (`repositories`.`repository_id` = SUBSTRING(`files`.`repository_id`, 1, 1024))
GROUP BY 1
So far we get an error:
[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.10-Vitess]unknown error: ambiguous column name "repository_id", it's present in all these tables: repositories, commits, files
SELECT SUBSTRING(`repositories`.`repository_id`, 1, 1024) AS `repository_id`
FROM `repositories`
INNER JOIN `commits` ON (SUBSTRING(`repositories`.`repository_id`, 1, 1024) = SUBSTRING(`commits`.`repository_id`, 1, 1024))
INNER JOIN `files` ON (`repositories`.`repository_id` = SUBSTRING(`files`.`repository_id`, 1, 1024))
GROUP BY 1