connect_work_size is not set properly

When I set the connect_work_size in /etc/my.cnf.d/connect.cnf
it seems to be set properly but is not working.
It goes alright when I indicate it using the set global command.

When I write inside /etc/my.cnf.d/connect.cnf below,

connect_work_size=536870912

I get in Maria,

show variables like 'connect_work_size';

+-------------------+-----------+

| Variable_name     | Value     |

+-------------------+-----------+

| connect_work_size | 536870912 |

+-------------------+-----------+

1 row in set (0.00 sec)

When inserting into a connect table (SQLServer2005 table on another server),
I get the following error inside /var/lib/mysql/servername.err

PlugSubAlloc: Not enough memory in Work area for request of 80 (used=67108792 free=72)

The size used+free is 64M, whcih is the default connect_work_size.
NOT THE SIZE SET IN MY CNF FILE!

When I set in Maria using the command,

set global connect_work_size=536870912;

the error changes to a correct one as below.

PlugSubAlloc: Not enough memory in Work area for request of 40 (used=536870888 free=24)