Re: Max length of SQl return string?

On 28/11/13 14:41, Alexander Silveröhrt wrote:

Hello,

We are doing a query which are supposed to comeback with a bunch of subscriber accounts.

update request { Subscriber-Accounts := "%{sql-cisco-bng:SELECT GROUP_CONCAT(username SEPARATOR ';') FROM radcheck WHERE username LIKE '%{User-Name}%%'}" }

But it seems that there is a limit on how long the return string can be?

Well, it's a radius attribute, so it's probably 253 bytes. Not sure if this limit is changed/removed in later versions of the server (e.g. for attributes which are internal, since they never go on the wire there's no protocol reason to limit their length)