SELECT /*+ SET_VAR(query_mem_limit = 8589934592) */ name FROM people ORDER BY name
starrocks set var 变量的作用域范围是怎样的,
比如下面的语句 WITH TEST_TRACE_INFO AS ( select /*+ SET_VAR(query_mem_limit = 8589934592) */ ‘1’ ) select * from tablea limit 10;
这整条语句也会用到这个变量吗?还是只是公共子查询 。