MSSQL Function STRING_AGG may not have a WITHIN GROUP clause

[joserocha]

Bug description

I am using SQL Server 2012 Enterprise for my production setup right now. I'm trying to construct a huge dataset in my development enviroment similar to what I have in my production environment to test my applications with a larger load and check that there are no performance concerns on SQL Server 2022. However, I receive the following problem whenever I attempt to start the job::

Id	Type	Time	Error
17	ActivityTaskScheduled	10/07/2024 02:44:00:143 PM
18	ActivityTaskStarted	10/07/2024 02:44:00:152 PM
19	ActivityTaskFailed	10/07/2024 02:44:00:367 PM	{"message": "unable to build benthos sql sync source config responses: unable to retrieve database table constraints: mssql: The function 'STRING_AGG' may not have a WITHIN GROUP clause.", "retryState": "MaximumAttemptsReached"}

The STRING_AGG function only exists from SQL Server 2017 onwards, but I would like to explore the possibility of supporting SQL 2012.

How to reproduce

1. Create two connections
2. Create a job and try to sync any table
3. Start the job

Environment

MSSQL 2012 Enterprise (source) MSSQL 2022 Developer (destination)

Additional context

Thank you for your bug report – we love squashing them!

[evisdrenova]

Thanks for reporting this @joserocha . We'll take a look and reply with any updates.