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] - add support for GROUP BY X #520

Closed
@kuba--

Description

@kuba--

Tableau spreadsheet sends following requests:

SELECT SUBSTRING(`commits`.`commit_hash`, 1, 1024) AS `commit_hash`
FROM `commits`
  INNER JOIN `files` ON (SUBSTRING(`commits`.`repository_id`, 1, 1024) = SUBSTRING(`files`.`repository_id`, 1, 1024))
  INNER JOIN `repositories` ON (`commits`.`repository_id` = SUBSTRING(`repositories`.`repository_id`, 1, 1024))
GROUP BY 1

what gets an unknown error:

MySQL][ODBC 5.3(w) Driver][mysqld-5.5.10-Vitess]unknown error: GroupBy aggregate expression 'SUBSTRING(commits.commit_hash, 1, 1024) as commit_hash' doesn't appear in the grouping columns

SELECT SUBSTRING(`commits`.`commit_hash`, 1, 1024) AS `commit_hash`
FROM `commits`
  INNER JOIN `files` ON (SUBSTRING(`commits`.`repository_id`, 1, 1024) = SUBSTRING(`files`.`repository_id`, 1, 1024))
  INNER JOIN `repositories` ON (`commits`.`repository_id` = SUBSTRING(`repositories`.`repository_id`, 1, 1024))
GROUP BY 1

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions