Skip to content
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
@kuba--

Description

@kuba--

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

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions