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

getAllTables doesn't get all tables on some MySQL setups #65

Closed
michalbiarda opened this issue Jan 31, 2023 · 0 comments
Closed

getAllTables doesn't get all tables on some MySQL setups #65

michalbiarda opened this issue Jan 31, 2023 · 0 comments
Assignees
@michalbiarda
Labels
bug
Milestone
4.0.0

Comments

@michalbiarda
Copy link
Contributor

Apparently there is a max length limit for GROUP_CONCAT function that is used inside getAllTables, and its default of 1024 is too low to get all tables from bigger databases (like Magento). We should raise the limit temporarily with SET SESSION group_concat_max_len = 1000000;
@michalbiarda michalbiarda added this to the 4.0.0 milestone Jan 31, 2023
@michalbiarda michalbiarda self-assigned this Jan 31, 2023
@michalbiarda michalbiarda moved this to In Progress in Driver Jan 31, 2023
michalbiarda added a commit that referenced this issue Jan 31, 2023
@michalbiarda
#65: getAllTables GROUP_CONCAT issue fixed
02263e6
michalbiarda added a commit that referenced this issue Jan 31, 2023
@michalbiarda
#65: getAllTables GROUP_CONCAT issue fixed (#66)
093f610
@github-project-automation github-project-automation bot moved this from In Progress to Done in Driver Feb 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@michalbiarda michalbiarda

Labels
bug
Projects
Driver
Status: Done
Milestone
4.0.0
Development

No branches or pull requests
1 participant
@michalbiarda