MySQL Forums
Forum List  »  Connector/Node.js

Re: how can I connect multiple select queries via UNION ALL.
Posted by: Peter Brawley
Date: June 29, 2020 02:01PM

It seems unlikely a user could learn anything from looking at the result of such a query, so presumably it's meant to be further processed.

In any case, the 61-table limit is hardwired AFAIK. What's more, Join Order optimisation complexity increases as the factorial of the table count, so attempts to skirt the 61-table limit are futile on both counts.

If it's me, I chunk the joins to generate intermediate tables.

Quote

LEFT JOIN sources AS sor
ON sor.id = meso.source_id
( SELECT m.id AS id, ...

That's a From clause syntax error.

Options: ReplyQuote


Subject
Written By
Posted
Re: how can I connect multiple select queries via UNION ALL.
June 29, 2020 02:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.