Thoughts while reviewing MySQL documention

[fallenpegasus]

Why may LIMIT only take a fixed number? Not even a user variable, let alone an expression.

Wouldn't it be useful to set a user session variable that always gets applied as an implicit limit value?

Both of these things could be done in Drizzle.

Comments

[elfs.livejournal.com]

That's why they pay you the big bucks.

[harrison-fisk.livejournal.com]

SQL_SELECT_LIMIT automatically limits results for every query on a session.

SET SQL_SELECT_LIMIT = 1;
SELECT * FROM test.tbl;

[supersnazz.livejournal.com]

That doesn't account for two-part LIMIT clauses, which is to say those with both a limit and an offset.

[harrison-fisk.livejournal.com]

Why would one want to use a session based offset/limit? I can see a definite use case for limiting all of the time, but not sure why one would want to always use an offset.

[fallenpegasus]

Cool, I did not know that.

Sometime I need to sit down and just read all the system variables.