zhiqiang-hhhh opened a new pull request, #30998: URL: https://github.com/apache/doris/pull/30998
we can filter session variables by changed column now ```txt mysql [demo]>show variables where changed=1; -------------- show variables where changed=1 -------------- +--------------------------+-------+--------------------+---------+ | Variable_name | Value | Default_Value | Changed | +--------------------------+-------+--------------------+---------+ | enable_nereids_trace | true | false | 1 | | runtime_filter_type | 8 | IN_OR_BLOOM_FILTER | 1 | | sql_mode | 1 | | 1 | | validate_password_policy | 0 | NONE | 1 | +--------------------------+-------+--------------------+---------+ 4 rows in set (0.03 sec) ``` and select from information_schema.session_variables is working too. ```txt mysql [demo]>select * from information_schema.session_variables where changed='1'; -------------- select * from information_schema.session_variables where changed='1' -------------- +--------------------------+----------------+--------------------+---------+ | VARIABLE_NAME | VARIABLE_VALUE | DEFAULT_VALUE | CHANGED | +--------------------------+----------------+--------------------+---------+ | enable_nereids_trace | true | false | 1 | | runtime_filter_type | 8 | IN_OR_BLOOM_FILTER | 1 | | sql_mode | 1 | | 1 | | validate_password_policy | 0 | NONE | 1 | +--------------------------+----------------+--------------------+---------+ 4 rows in set (0.04 sec) ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
