Allow the statement "SET SESSION" in a SQL query.#202

Sometimes it is necessary to adjust server variables in a session. However, “SET SESSION” is blocked by wpdatatables.

SET SESSION group_concat_max_len = 3000;

It would be great if you allowed “SET SESSION”.

Great idea, I also need this extension for my SQL-statement with GROUP_CONCAT.

That should be easy to resolved.

My provider doesn’t want to increase the session variable for everyone. For this reason I also rely on the local increase via SET SESSION. Very annoying …

I also have the same problem. My provider refuses to adjust the variable globally.
Setting the local variable would help me a lot.

Many people agree but nothing happens. What a pity.

So much agreement but no reaction from support. That’s a real shame.