Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[MYSQL] Fix columnInfo showing column multiple times. #69

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

[MYSQL] Fix columnInfo showing column multiple times. #69

wants to merge 1 commit into from

Conversation

Nitwel
Copy link

@Nitwel Nitwel commented Sep 6, 2021

closes #63

@rijkvanzanten
Copy link
Collaborator

@Oreilles looking good>?

@Oreilles
Copy link
Contributor

Oreilles commented Sep 7, 2021 •
edited
Loading

I would do a left join lateral with limit 1 instead, that would avoid calculating the row number and adding the last where close.
EDIT: apparently not possible, I thought it was Postgres, LATERAL only was added to MySQL in 8.0.

@Oreilles
Copy link
Contributor

Oreilles commented Sep 7, 2021

We should add a test for this adding multiple indicies on one column. And for other vendors as well

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees

@Nitwel Nitwel

@Oreilles Oreilles

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

MySQL columnInfo(): Duplicated rows when more than 1 index exists for a field
3 participants
@Nitwel @rijkvanzanten @Oreilles