[Bug]: 1116 Too many tables; MySQL can only use 61 tables in a join

[ubuntu-r360]

Expected behavior

I have pimcore 6 with dev version of datahub. Then i update to pimcore 10 and datahub 1.2.4 all work fine. Then update to 1.7.0.

Actual behavior

Error on request 1116 Too many tables; MySQL can only use 61 tables in a join

Steps to reproduce

I have pimcore 6 with dev version of datahub. Then i update to pimcore 10 and datahub 1.2.4 all work fine. Then update to 1.7.0.

[github-actions]

Thanks a lot for reporting the issue. We did not consider the issue as "Pimcore:Priority", "Pimcore:ToDo" or "Pimcore:Backlog", so we're not going to work on that anytime soon. Please create a pull request to fix the issue if this is a bug report. We'll then review it as quickly as possible. If you're interested in contributing a feature, please contact us first here before creating a pull request. We'll then decide whether we'd accept it or not. Thanks for your understanding.

[fashxp]

please share your request and eventually your data model.
thanks.

[mcop1]

Hello @ubuntu-r360 ,

could you please, as fashxp mentioned, share your graphql query, data-hub configuration and data object model?

Thank you for your efforts.