Error Using Query RDBMS Node

Question

I am trying to use the Query Database node to execute a query that performs a GROUP_CONCAT() function on a field in a table in the mysql db. When I do I get the following error. Errors There was a problem during the validation of the SQL statement with the database The Column name GROUP_CONCAT(id) is invalid. Please use 'as' clause with function calls The database returned ARV's that may not be supported. Message: GROUP_CONCAT(id) If I do as the error suggests and use the AS to give the table an alias I get the following error. Errors There was a problem during the validation of the SQL statement with the database The database returned ARV's that may not be supported. Message: ids Is there something I have to do to get the GROUP_CONCAT() function to work? ... 
 OriginalPostID-34498 
 OriginalPostID-34498

acottrell · Accepted Answer

Thanks. I found out what I was doing wrong. The field I am using is an int. I had to cast it as a char in the group_concat() function to get it to work.