[MDEV-27462] SET STATEMENT allows variables that cannot be set per query basis Created: 2022-01-10  Updated: 2023-11-28

Status: Stalled
Project: MariaDB Server
Component/s: Variables
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0

Type: Bug Priority: Major
Reporter: Rucha Deodhar Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 1
Labels: affects-tests

Issue Links:
Relates
relates to MDEV-5231 Per query variables from Percona Serv... Closed
relates to MDEV-14760 Replication does not take into accoun... Stalled
relates to MDEV-22768 Assertion `! is_set() || m_can_overwr... Stalled

 Description   

SET STATEMENT allows variables that should not be allowed to set per query basis.
Example:
default_master_connection, last_insert_id, log_slow_filter, log_slow_rate_limit, log_slow_verbosity, long_query_time, min_examined_row_limit, rand_seed1, rand_seed2, slow_query_log

See limitation



 Comments   
Comment by Rucha Deodhar [ 2022-01-10 ]

Patch: https://github.com/MariaDB/server/commit/ebb5acf947b2699ce9596677c3a4a3f429644556

Comment by Roel Van de Paar [ 2022-02-16 ]

sanja A review for this patch would be appreciated as this patch may resolve MDEV-22768 which affects tests significantly. Thank you

Comment by Rucha Deodhar [ 2022-03-29 ]

Reassigning to myself to check why those variables can't be set and if any other system variable should go to the disallowed list.

Comment by Rucha Deodhar [ 2022-09-21 ]

Roel Hi ! I have found the list of variables that should be disallowed. But some are confusing. I am waiting for what sanja thinks. (Should have reassigned it)

Generated at Thu Feb 08 09:53:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.