Supermetrics Support Forum

SET SESSION for SQL query

I am running query which contains a group concat. The max length for group concat is 1024 characters, but the result i am looking for is longer in some cases.

 

This can be circumvented by running "SET SESSION group_concat_max_len = 1000000;" before the SELECT query. I have tried this in MySQL workbench and it works, but unfortunately it doesnt in SuperMetrics.

 

https://groups.google.com/forum/#!msg/automateanalytics/CKhHWZ3uraI/NregPkOVFQAJ

It seems someone else has run into t his problem before and it was fixed, but it doesnt work for me. Do you have any idea what im doing wrong?

 

Thanks!


Login to post a comment