Use tpch 10g data and SET TIFLASH REPLICA for two tables below. mysql> set sql_mode = 'ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO ...
Currently, StarRocks supports GROUP_CONCAT(expr [ORDER BY ...] [SEPARATOR sep]), which is MySQL-compatible. However, many users coming from PostgreSQL or SQL Server are accustomed to STRING_AGG, which ...