News

To Reproduce Add ClickHouse and Knowledge-> Add questioin-SQL pair SELECT ip, groupUniqArray(port) AS ports FROM table GROUP BY ip Ask question and generated SQL SELECT ip, GROUPUNIQARRAY(port) AS ...
Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause: createdon Using SQL-4-CDS v6.4.0.0 inside the XrmToolbox.