#5306 is way too big, weren't you going to split that up into smaller PRs?

As for "LIMIT 18446744073709551615 OFFSET 10" is this a common MySQL practice?  What are the side effects of this inside the mysql engine.

It seems to me that if if the platform wants both limit and offset, then the developer should ensure that in practice they are supplying both.