✘ 260ms [ Fail ] /rbac/part 1/syntax/alter user/I alter user default role multiple Nov 13,2025 0:45:04 ⟥ Scenario I alter user default role multiple, flags:TE Requirements RQ.SRS-006.RBAC.User.Alter.DefaultRole version 1.0 Nov 13,2025 0:45:04 ⟥ Given I have a user, flags:MANDATORY|SETUP Nov 13,2025 0:45:04 ⟥ By executing command echo -e "CREATE USER OR REPLACE user15" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "CREATE USER OR REPLACE user15" | clickhouse client -n 2>&1 75ms [clickhouse1] Received exception from server (version 25.11.1): 76ms [clickhouse1] Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/38373166-2d31-6134-6164-373733313063.sql. (FILE_DOESNT_EXIST) 76ms [clickhouse1] (query: CREATE USER OR REPLACE user15 76ms [clickhouse1] ) 88ms [clickhouse1] bash# echo $? 89ms [clickhouse1] 107 89ms [clickhouse1] bash# 90ms ⟥⟤ OK executing command, /rbac/part 1/syntax/alter user/I alter user default role multiple/I have a user/executing command Nov 13,2025 0:45:04 ⟥ Then check if output has exception 79ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 8, in feature Feature(run=load("rbac.tests.syntax.alter_user", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/alter_user.py", line 310, in feature with setup("user15"), setup_role("second"), setup_role("third"): File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/alter_user.py", line 31, in setup node.query(f"CREATE USER OR REPLACE {user}") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/38373166-2d31-6134-6164-373733313063.sql. (FILE_DOESNT_EXIST) (query: CREATE USER OR REPLACE user15 ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 80ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/alter user/I alter user default role multiple/I have a user/check if output has exception, AssertionError 172ms ⟥⟤ Fail I have a user, /rbac/part 1/syntax/alter user/I alter user default role multiple/I have a user, AssertionError Nov 13,2025 0:45:05 ⟥ Finally I drop the user, flags:TE|MANDATORY|CLEANUP Nov 13,2025 0:45:05 ⟥ By executing command echo -e "DROP USER IF EXISTS user15" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "DROP USER IF EXISTS user15" | clickhouse client -n 2>&1 81ms [clickhouse1] bash# echo $? 81ms [clickhouse1] 0 82ms [clickhouse1] bash# 83ms ⟥⟤ OK executing command, /rbac/part 1/syntax/alter user/I alter user default role multiple/I drop the user/executing command Nov 13,2025 0:45:05 ⟥ Then check if output has exception 1ms ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/alter user/I alter user default role multiple/I drop the user/check if output has exception 86ms ⟥⟤ OK I drop the user, /rbac/part 1/syntax/alter user/I alter user default role multiple/I drop the user 260ms ⟥⟤ Fail I alter user default role multiple, /rbac/part 1/syntax/alter user/I alter user default role multiple, AssertionError AssertionError ✘ 12s 685ms [ Fail ] /rbac/part 1/syntax/alter user AssertionError ✘ 199ms [ Fail ] /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist Nov 13,2025 0:48:01 ⟥ Scenario I drop row policy if exists, policy does exist, flags:TE Requirements RQ.SRS-006.RBAC.RowPolicy.Drop.IfExists version 1.0 RQ.SRS-006.RBAC.RowPolicy.Drop.On version 1.0 Nov 13,2025 0:48:01 ⟥ Given I have a row policy, flags:MANDATORY|SETUP Nov 13,2025 0:48:01 ⟥ By executing command echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 81ms [clickhouse1] Received exception from server (version 25.11.1): 81ms [clickhouse1] Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) 82ms [clickhouse1] (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo 82ms [clickhouse1] ) 96ms [clickhouse1] bash# echo $? 96ms [clickhouse1] 107 97ms [clickhouse1] bash# 98ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist/I have a row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 10ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 22, in feature Feature(run=load("rbac.tests.syntax.drop_row_policy", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 92, in feature with cleanup(["policy3"]): File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 26, in cleanup node.query(f"CREATE ROW POLICY OR REPLACE {i} ON {j}") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 12ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist/I have a row policy/check if output has exception, AssertionError 112ms ⟥⟤ Fail I have a row policy, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist/I have a row policy, AssertionError Nov 13,2025 0:48:02 ⟥ Finally I drop the row policy, flags:TE|MANDATORY|CLEANUP Nov 13,2025 0:48:02 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 81ms [clickhouse1] bash# echo $? 81ms [clickhouse1] 0 82ms [clickhouse1] bash# 83ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist/I drop the row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 937us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist/I drop the row policy/check if output has exception 85ms ⟥⟤ OK I drop the row policy, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist/I drop the row policy 199ms ⟥⟤ Fail I drop row policy if exists, policy does exist, /rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist, AssertionError AssertionError ✘ 251ms [ Fail ] /rbac/part 1/syntax/drop row policy/I drop multiple row policies Nov 13,2025 0:48:02 ⟥ Scenario I drop multiple row policies, flags:TE Requirements RQ.SRS-006.RBAC.RowPolicy.Drop version 1.0 RQ.SRS-006.RBAC.RowPolicy.Drop.On version 1.0 Nov 13,2025 0:48:02 ⟥ Given I have a row policy, flags:MANDATORY|SETUP Nov 13,2025 0:48:02 ⟥ By executing command echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 71ms [clickhouse1] Received exception from server (version 25.11.1): 73ms [clickhouse1] Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) 74ms [clickhouse1] (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo 74ms [clickhouse1] ) 79ms [clickhouse1] bash# echo $? 79ms [clickhouse1] 107 80ms [clickhouse1] bash# 80ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I have a row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 6ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 22, in feature Feature(run=load("rbac.tests.syntax.drop_row_policy", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 114, in feature with cleanup(["policy3", "policy4"]): File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 26, in cleanup node.query(f"CREATE ROW POLICY OR REPLACE {i} ON {j}") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 8ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I have a row policy/check if output has exception, AssertionError 90ms ⟥⟤ Fail I have a row policy, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I have a row policy, AssertionError Nov 13,2025 0:48:02 ⟥ Finally I drop the row policy, flags:TE|MANDATORY|CLEANUP Nov 13,2025 0:48:02 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 80ms [clickhouse1] bash# echo $? 81ms [clickhouse1] 0 81ms [clickhouse1] bash# 82ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I drop the row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 773us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I drop the row policy/check if output has exception Nov 13,2025 0:48:02 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy4 ON default.foo" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy4 ON default.foo" | clickhouse client -n 2>&1 73ms [clickhouse1] bash# echo $? 73ms [clickhouse1] 0 74ms [clickhouse1] bash# 74ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I drop the row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 747us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I drop the row policy/check if output has exception 159ms ⟥⟤ OK I drop the row policy, /rbac/part 1/syntax/drop row policy/I drop multiple row policies/I drop the row policy 251ms ⟥⟤ Fail I drop multiple row policies, /rbac/part 1/syntax/drop row policy/I drop multiple row policies, AssertionError AssertionError ✘ 265ms [ Fail ] /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables Nov 13,2025 0:48:02 ⟥ Scenario I drop row policy on multiple tables, flags:TE Requirements RQ.SRS-006.RBAC.RowPolicy.Drop version 1.0 RQ.SRS-006.RBAC.RowPolicy.Drop.On version 1.0 Nov 13,2025 0:48:02 ⟥ Given I have a row policy, flags:MANDATORY|SETUP Nov 13,2025 0:48:02 ⟥ By executing command echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 71ms [clickhouse1] Received exception from server (version 25.11.1): 71ms [clickhouse1] Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) 71ms [clickhouse1] (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo 71ms [clickhouse1] ) 84ms [clickhouse1] bash# echo $? 85ms [clickhouse1] 107 86ms [clickhouse1] bash# 86ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I have a row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 5ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 22, in feature Feature(run=load("rbac.tests.syntax.drop_row_policy", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 125, in feature with cleanup(["policy3"], ["default.foo", "default.foo2"]): File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 26, in cleanup node.query(f"CREATE ROW POLICY OR REPLACE {i} ON {j}") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 6ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I have a row policy/check if output has exception, AssertionError 94ms ⟥⟤ Fail I have a row policy, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I have a row policy, AssertionError Nov 13,2025 0:48:02 ⟥ Finally I drop the row policy, flags:TE|MANDATORY|CLEANUP Nov 13,2025 0:48:02 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 85ms [clickhouse1] bash# echo $? 85ms [clickhouse1] 0 86ms [clickhouse1] bash# 86ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I drop the row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 878us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I drop the row policy/check if output has exception Nov 13,2025 0:48:02 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo2" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo2" | clickhouse client -n 2>&1 77ms [clickhouse1] bash# echo $? 78ms [clickhouse1] 0 78ms [clickhouse1] bash# 79ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I drop the row policy/executing command Nov 13,2025 0:48:02 ⟥ Then check if output has exception 766us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I drop the row policy/check if output has exception 169ms ⟥⟤ OK I drop the row policy, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables/I drop the row policy 265ms ⟥⟤ Fail I drop row policy on multiple tables, /rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables, AssertionError AssertionError ✘ 450ms [ Fail ] /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables Nov 13,2025 0:48:02 ⟥ Scenario I drop multiple row policies on multiple tables, flags:TE Requirements RQ.SRS-006.RBAC.RowPolicy.Drop version 1.0 RQ.SRS-006.RBAC.RowPolicy.Drop.On version 1.0 Nov 13,2025 0:48:02 ⟥ Given I have a row policy, flags:MANDATORY|SETUP Nov 13,2025 0:48:02 ⟥ By executing command echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "CREATE ROW POLICY OR REPLACE policy3 ON default.foo" | clickhouse client -n 2>&1 69ms [clickhouse1] Received exception from server (version 25.11.1): 69ms [clickhouse1] Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) 69ms [clickhouse1] (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo 69ms [clickhouse1] ) 82ms [clickhouse1] bash# echo $? 83ms [clickhouse1] 107 83ms [clickhouse1] bash# 84ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I have a row policy/executing command Nov 13,2025 0:48:03 ⟥ Then check if output has exception 5ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 22, in feature Feature(run=load("rbac.tests.syntax.drop_row_policy", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 136, in feature with cleanup(["policy3", "policy4"], ["default.foo", "default.foo2"]): File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/drop_row_policy.py", line 26, in cleanup node.query(f"CREATE ROW POLICY OR REPLACE {i} ON {j}") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/00000000-1407-fdd2-0000-00001408779a.sql. (FILE_DOESNT_EXIST) (query: CREATE ROW POLICY OR REPLACE policy3 ON default.foo ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 7ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I have a row policy/check if output has exception, AssertionError 92ms ⟥⟤ Fail I have a row policy, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I have a row policy, AssertionError Nov 13,2025 0:48:03 ⟥ Finally I drop the row policy, flags:TE|MANDATORY|CLEANUP Nov 13,2025 0:48:03 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo" | clickhouse client -n 2>&1 79ms [clickhouse1] bash# echo $? 79ms [clickhouse1] 0 80ms [clickhouse1] bash# 80ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/executing command Nov 13,2025 0:48:03 ⟥ Then check if output has exception 669us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/check if output has exception Nov 13,2025 0:48:03 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo2" | clickhouse client -n 2>&1 7ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy3 ON default.foo2" | clickhouse client -n 2>&1 87ms [clickhouse1] bash# echo $? 87ms [clickhouse1] 0 88ms [clickhouse1] bash# 89ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/executing command Nov 13,2025 0:48:03 ⟥ Then check if output has exception 823us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/check if output has exception Nov 13,2025 0:48:03 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy4 ON default.foo" | clickhouse client -n 2>&1 9ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy4 ON default.foo" | clickhouse client -n 2>&1 89ms [clickhouse1] bash# echo $? 89ms [clickhouse1] 0 90ms [clickhouse1] bash# 90ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/executing command Nov 13,2025 0:48:03 ⟥ Then check if output has exception 897us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/check if output has exception Nov 13,2025 0:48:03 ⟥ By executing command echo -e "DROP ROW POLICY IF EXISTS policy4 ON default.foo2" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "DROP ROW POLICY IF EXISTS policy4 ON default.foo2" | clickhouse client -n 2>&1 88ms [clickhouse1] bash# echo $? 88ms [clickhouse1] 0 89ms [clickhouse1] bash# 89ms ⟥⟤ OK executing command, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/executing command Nov 13,2025 0:48:03 ⟥ Then check if output has exception 892us ⟥⟤ OK check if output has exception, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy/check if output has exception 356ms ⟥⟤ OK I drop the row policy, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables/I drop the row policy 450ms ⟥⟤ Fail I drop multiple row policies on multiple tables, /rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables, AssertionError AssertionError ✘ 3s 705ms [ Fail ] /rbac/part 1/syntax/drop row policy AssertionError ✘ 113ms [ Fail ] /rbac/part 1/syntax/alter quota/I alter quota keyed by none Nov 13,2025 0:48:20 ⟥ Scenario I alter quota keyed by none, flags:TE Requirements RQ.SRS-006.RBAC.Quota.Alter.KeyedBy version 1.0 RQ.SRS-006.RBAC.Quota.Alter.KeyedByOptions version 1.0 Nov 13,2025 0:48:20 ⟥ When I alter quota with a key Nov 13,2025 0:48:20 ⟥ By executing command echo -e "ALTER QUOTA quota0 KEYED BY 'none'" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "ALTER QUOTA quota0 KEYED BY 'none'" | clickhouse client -n 2>&1 67ms [clickhouse1] Received exception from server (version 25.11.1): 68ms [clickhouse1] Code: 493. DB::Exception: Received from localhost:9000. DB::Exception: quota `quota1`: cannot rename to `quota0` because quota `quota0` already exists in `local_directory`. (ACCESS_ENTITY_ALREADY_EXISTS) 68ms [clickhouse1] (query: ALTER QUOTA quota0 KEYED BY 'none' 68ms [clickhouse1] ) 91ms [clickhouse1] bash# echo $? 92ms [clickhouse1] 237 93ms [clickhouse1] bash# 93ms ⟥⟤ OK executing command, /rbac/part 1/syntax/alter quota/I alter quota keyed by none/I alter quota with a key/executing command Nov 13,2025 0:48:20 ⟥ Then check if output has exception 11ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 26, in feature Feature(run=load("rbac.tests.syntax.alter_quota", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/alter_quota.py", line 119, in feature node.query(f"ALTER QUOTA quota0 KEYED BY '{key}'") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 493. DB::Exception: Received from localhost:9000. DB::Exception: quota `quota1`: cannot rename to `quota0` because quota `quota0` already exists in `local_directory`. (ACCESS_ENTITY_ALREADY_EXISTS) (query: ALTER QUOTA quota0 KEYED BY 'none' ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 15ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/alter quota/I alter quota keyed by none/I alter quota with a key/check if output has exception, AssertionError 111ms ⟥⟤ Fail I alter quota with a key, /rbac/part 1/syntax/alter quota/I alter quota keyed by none/I alter quota with a key, AssertionError 113ms ⟥⟤ Fail I alter quota keyed by none, /rbac/part 1/syntax/alter quota/I alter quota keyed by none, AssertionError AssertionError ✘ 5s 816ms [ Fail ] /rbac/part 1/syntax/alter quota AssertionError ✘ 108ms [ Fail ] /rbac/part 1/syntax/alter settings profile/I alter settings profile with a setting value Nov 13,2025 0:48:41 ⟥ Scenario I alter settings profile with a setting value, flags:TE Requirements RQ.SRS-006.RBAC.SettingsProfile.Alter.Variables version 1.0 RQ.SRS-006.RBAC.SettingsProfile.Alter.Variables.Value version 1.0 Nov 13,2025 0:48:41 ⟥ When I alter settings profile using settings Nov 13,2025 0:48:41 ⟥ By executing command echo -e "ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage = 100000001" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage = 100000001" | clickhouse client -n 2>&1 65ms [clickhouse1] Received exception from server (version 25.11.1): 65ms [clickhouse1] Code: 493. DB::Exception: Received from localhost:9000. DB::Exception: settings profile `profile1`: cannot rename to `profile0` because settings profile `profile0` already exists in `local_directory`. (ACCESS_ENTITY_ALREADY_EXISTS) 65ms [clickhouse1] (query: ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage = 100000001 65ms [clickhouse1] ) 84ms [clickhouse1] bash# echo $? 85ms [clickhouse1] 237 86ms [clickhouse1] bash# 87ms ⟥⟤ OK executing command, /rbac/part 1/syntax/alter settings profile/I alter settings profile with a setting value/I alter settings profile using settings/executing command Nov 13,2025 0:48:41 ⟥ Then check if output has exception 14ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 31, in feature Feature(run=load("rbac.tests.syntax.alter_settings_profile", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/alter_settings_profile.py", line 126, in feature node.query( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 493. DB::Exception: Received from localhost:9000. DB::Exception: settings profile `profile1`: cannot rename to `profile0` because settings profile `profile0` already exists in `local_directory`. (ACCESS_ENTITY_ALREADY_EXISTS) (query: ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage = 100000001 ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 18ms ⟥⟤ Fail check if output has exception, /rbac/part 1/syntax/alter settings profile/I alter settings profile with a setting value/I alter settings profile using settings/check if output has exception, AssertionError 106ms ⟥⟤ Fail I alter settings profile using settings, /rbac/part 1/syntax/alter settings profile/I alter settings profile with a setting value/I alter settings profile using settings, AssertionError 108ms ⟥⟤ Fail I alter settings profile with a setting value, /rbac/part 1/syntax/alter settings profile/I alter settings profile with a setting value, AssertionError AssertionError ✘ 5s 243ms [ Fail ] /rbac/part 1/syntax/alter settings profile AssertionError ✘ 109ms [ Fail ] /rbac/part 1/syntax/set default role/I set one default role for user default, throws exception Nov 13,2025 0:48:49 ⟥ Scenario I set one default role for user default, throws exception, flags:TE Requirements RQ.SRS-006.RBAC.SetDefaultRole version 1.0 Nov 13,2025 0:48:49 ⟥ When I set a default role for default Nov 13,2025 0:48:49 ⟥ By executing command echo -e "SET DEFAULT ROLE role0 TO default" | clickhouse client -n 2>&1 4ms [clickhouse1] bash# echo -e "SET DEFAULT ROLE role0 TO default" | clickhouse client -n 2>&1 80ms [clickhouse1] Received exception from server (version 25.11.1): 80ms [clickhouse1] Code: 512. DB::Exception: Received from localhost:9000. DB::Exception: Role should be granted to set default. (SET_NON_GRANTED_ROLE) 80ms [clickhouse1] (query: SET DEFAULT ROLE role0 TO default 80ms [clickhouse1] ) 96ms [clickhouse1] bash# echo $? 96ms [clickhouse1] 0 97ms [clickhouse1] bash# 97ms ⟥⟤ OK executing command, /rbac/part 1/syntax/set default role/I set one default role for user default, throws exception/I set a default role for default/executing command Nov 13,2025 0:48:49 ⟥ Then exitcode should be 239 7ms ⟥ Exception: Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 34, in feature Feature(run=load("rbac.tests.syntax.set_default_role", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/set_default_role.py", line 119, in feature node.query( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1189, in query assert r.exitcode == exitcode, error(r.output) ^^^^^^^^^^^^^^^^^^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert r.exitcode == exitcode, error(r.output) Description Received exception from server (version 25.11.1): Code: 512. DB::Exception: Received from localhost:9000. DB::Exception: Role should be granted to set default. (SET_NON_GRANTED_ROLE) (query: SET DEFAULT ROLE role0 TO default ) Assertion values assert r.exitcode == exitcode, error(r.output) ^ is assert r.exitcode == exitcode, error(r.output) ^ is = 0 assert r.exitcode == exitcode, error(r.output) ^ is 239 assert r.exitcode == exitcode, error(r.output) ^ is = False assert r.exitcode == exitcode, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1189 in 'query' 1181| **kwargs, 1182| ) 1183| 1184| if no_checks: 1185| return r 1186| 1187| if exitcode is not None: 1188| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 1189|> assert r.exitcode == exitcode, error(r.output) 1190| 1191| if message is not None: 1192| with ( 9ms ⟥⟤ Fail exitcode should be 239, /rbac/part 1/syntax/set default role/I set one default role for user default, throws exception/I set a default role for default/exitcode should be 239, AssertionError 108ms ⟥⟤ Fail I set a default role for default, /rbac/part 1/syntax/set default role/I set one default role for user default, throws exception/I set a default role for default, AssertionError 109ms ⟥⟤ Fail I set one default role for user default, throws exception, /rbac/part 1/syntax/set default role/I set one default role for user default, throws exception, AssertionError AssertionError ✘ 2s 676ms [ Fail ] /rbac/part 1/syntax/set default role AssertionError ✘ 4m 5s [ Fail ] /rbac/part 1/syntax AssertionError ✘ 5s 107ms [ Fail ] /rbac/part 1/privileges/create table/create as another table Nov 13,2025 1:01:30 ⟥ Scenario create as another table, flags:TE|PARALLEL Check that user is able to create a table as another table with only CREATE TABLE privilege. Arguments node None Nov 13,2025 1:01:30 ⟥ Given I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree, flags:MANDATORY|SETUP Nov 13,2025 1:01:30 ⟥ By executing command echo -e "DROP TABLE IF EXISTS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52" | clickhouse client -n 2>&1 Nov 13,2025 1:01:30 ⟥ And attempt #0 94ms [bash] bash# docker-compose --log-level ERROR --ansi never --project-directory "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/rbac_env" --file "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/rbac_env/docker-compose.yml" ps -q clickhouse1 208ms [bash] 71f15379956426a1b9bd392b74fe71c4a569186dc1cbc4a91eadd3043a4e8e69 212ms [bash] bash# echo $? 213ms [bash] 0 213ms [bash] bash# 213ms ⟥⟤ OK attempt #0, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree/executing command/attempt #0 Nov 13,2025 1:01:30 ⟥ And attempt #0 121ms [clickhouse1] clickhouse1:/# unset PROMPT_COMMAND; export PS1="bash# " 124ms [clickhouse1] bash# echo 1 125ms [clickhouse1] 1 127ms [clickhouse1] bash# echo $? 127ms [clickhouse1] 0 128ms [clickhouse1] bash# 128ms ⟥⟤ OK attempt #0, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree/executing command/attempt #0 772ms [clickhouse1] bash# echo -e "DROP TABLE IF EXISTS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52" | clickhouse client -n 2>&1 860ms [clickhouse1] bash# echo $? 860ms [clickhouse1] 0 861ms [clickhouse1] bash# 861ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree/executing command Nov 13,2025 1:01:31 ⟥ Then check if output has exception 896us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree/check if output has exception Nov 13,2025 1:01:31 ⟥ By executing command echo -e "CREATE TABLE source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 (d DATE, a String, b UInt8, x String, y Int8) ENGINE = MergeTree() PARTITION BY y ORDER BY (b, d) PRIMARY KEY b" | clickhouse client -n 2>&1 2s 195ms [clickhouse1] bash# echo -e "CREATE TABLE source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 (d DATE, a String, b UInt8, x String, y Int8) ENGINE = MergeTree() PARTITION BY y ORDER BY (b, d) PRIMARY KEY b" | clickhouse client -n 2>&1 2s 547ms [clickhouse1] bash# echo $? 2s 550ms [clickhouse1] 0 2s 551ms [clickhouse1] bash# 2s 551ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree/executing command Nov 13,2025 1:01:33 ⟥ Then check if output has exception 609us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree/check if output has exception 3s 420ms ⟥⟤ OK I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree, /rbac/part 1/privileges/create table/create as another table/I have source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 with engine MergeTree Nov 13,2025 1:01:33 ⟥ Given I have a user, flags:MANDATORY|SETUP Nov 13,2025 1:01:33 ⟥ By executing command echo -e "CREATE USER OR REPLACE user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" | clickhouse client -n 2>&1 65ms [clickhouse1] bash# echo -e "CREATE USER OR REPLACE user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" | clickhouse client -n 2>&1 310ms [clickhouse1] bash# echo $? 336ms [clickhouse1] 0 341ms [clickhouse1] bash# 360ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I have a user/executing command Nov 13,2025 1:01:34 ⟥ Then check if output has exception 13ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I have a user/check if output has exception 388ms ⟥⟤ OK I have a user, /rbac/part 1/privileges/create table/create as another table/I have a user Nov 13,2025 1:01:34 ⟥ When I grant CREATE TABLE privilege to a user Nov 13,2025 1:01:34 ⟥ By executing command echo -e "GRANT CREATE TABLE ON table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52 TO user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" | clickhouse client -n 2>&1 83ms [clickhouse1] bash# echo -e "GRANT CREATE TABLE ON table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52 TO user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" | clickhouse client -n 2>&1 278ms [clickhouse1] bash# echo $? 317ms [clickhouse1] 0 319ms [clickhouse1] bash# 319ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I grant CREATE TABLE privilege to a user/executing command Nov 13,2025 1:01:34 ⟥ Then check if output has exception 702us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I grant CREATE TABLE privilege to a user/check if output has exception 330ms ⟥⟤ OK I grant CREATE TABLE privilege to a user, /rbac/part 1/privileges/create table/create as another table/I grant CREATE TABLE privilege to a user Nov 13,2025 1:01:34 ⟥ Then I try to create a table as another table Nov 13,2025 1:01:34 ⟥ By executing command echo -e "CREATE TABLE table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52 AS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52" | clickhouse client -n --user "user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" 2>&1 7ms [clickhouse1] bash# echo -e "CREATE TABLE table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52 AS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52" | clickhouse client -n --user "user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" 2>&1 172ms [clickhouse1] Received exception from server (version 25.11.1): 177ms [clickhouse1] Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52: Not enough privileges. To execute this query, it's necessary to have the grant SHOW TABLES ON default.source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52. (ACCESS_DENIED) 177ms [clickhouse1] (query: CREATE TABLE table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52 AS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 178ms [clickhouse1] ) 206ms [clickhouse1] bash# echo $? 207ms [clickhouse1] 241 213ms [clickhouse1] bash# 219ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I try to create a table as another table/executing command Nov 13,2025 1:01:34 ⟥ Then check if output has exception 25ms ⟥ Exception: Traceback (most recent call last): File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap self._bootstrap_inner() File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner self.run() File "/usr/lib/python3.12/threading.py", line 1010, in run self._target(*self._args, **self._kwargs) File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run result = self.fn(*self.args, **self.kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/create/create_table.py", line 1084, in create_as_another_table node.query( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52: Not enough privileges. To execute this query, it's necessary to have the grant SHOW TABLES ON default.source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52. (ACCESS_DENIED) (query: CREATE TABLE table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52 AS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| 34ms ⟥⟤ Fail check if output has exception, /rbac/part 1/privileges/create table/create as another table/I try to create a table as another table/check if output has exception, AssertionError 258ms ⟥⟤ Fail I try to create a table as another table, /rbac/part 1/privileges/create table/create as another table/I try to create a table as another table, AssertionError Nov 13,2025 1:01:34 ⟥ Finally I drop the tables, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:01:34 ⟥ By executing command echo -e "DROP TABLE IF EXISTS table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52" | clickhouse client -n 2>&1 46ms [clickhouse1] bash# echo -e "DROP TABLE IF EXISTS table_create_as_another_table_4a39dd9f_c02c_11f0_be71_920006bc6c52" | clickhouse client -n 2>&1 214ms [clickhouse1] bash# echo $? 218ms [clickhouse1] 0 224ms [clickhouse1] bash# 224ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I drop the tables/executing command Nov 13,2025 1:01:35 ⟥ Then check if output has exception 1ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I drop the tables/check if output has exception 227ms ⟥⟤ OK I drop the tables, /rbac/part 1/privileges/create table/create as another table/I drop the tables Nov 13,2025 1:01:35 ⟥ Finally I drop the user, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:01:35 ⟥ By executing command echo -e "DROP USER IF EXISTS user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" | clickhouse client -n 2>&1 41ms [clickhouse1] bash# echo -e "DROP USER IF EXISTS user_create_as_another_table_4a39dd23_c02c_11f0_9dbc_920006bc6c52" | clickhouse client -n 2>&1 176ms [clickhouse1] bash# echo $? 176ms [clickhouse1] 0 177ms [clickhouse1] bash# 177ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I drop the user/executing command Nov 13,2025 1:01:35 ⟥ Then check if output has exception 764us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I drop the user/check if output has exception 179ms ⟥⟤ OK I drop the user, /rbac/part 1/privileges/create table/create as another table/I drop the user Nov 13,2025 1:01:35 ⟥ Finally I drop the table source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:01:35 ⟥ By executing command echo -e "DROP TABLE IF EXISTS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "DROP TABLE IF EXISTS source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52" | clickhouse client -n 2>&1 236ms [clickhouse1] bash# echo $? 236ms [clickhouse1] 0 247ms [clickhouse1] bash# 282ms ⟥⟤ OK executing command, /rbac/part 1/privileges/create table/create as another table/I drop the table source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52/executing command Nov 13,2025 1:01:35 ⟥ Then check if output has exception 915us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/create table/create as another table/I drop the table source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52/check if output has exception 284ms ⟥⟤ OK I drop the table source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52, /rbac/part 1/privileges/create table/create as another table/I drop the table source_table_create_as_another_table_4a39ddeb_c02c_11f0_a301_920006bc6c52 5s 107ms ⟥⟤ Fail create as another table, /rbac/part 1/privileges/create table/create as another table, AssertionError AssertionError ✘ 979ms [ Fail ] /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege Nov 13,2025 1:02:36 ⟥ Suite user with direct privilege, flags:TE Nov 13,2025 1:02:36 ⟥ Given I have a user, flags:MANDATORY|SETUP Nov 13,2025 1:02:36 ⟥ By executing command echo -e "CREATE USER OR REPLACE user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 36ms [clickhouse1] bash# echo -e "CREATE USER OR REPLACE user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 154ms [clickhouse1] bash# echo $? 154ms [clickhouse1] 0 155ms [clickhouse1] bash# 155ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I have a user/executing command Nov 13,2025 1:02:36 ⟥ Then check if output has exception 2ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I have a user/check if output has exception 159ms ⟥⟤ OK I have a user, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I have a user Nov 13,2025 1:02:36 ⟥ When I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges Nov 13,2025 1:02:36 ⟥ Step user without privilege Nov 13,2025 1:02:36 ⟥ When I grant the user NONE privilege Nov 13,2025 1:02:36 ⟥ By executing command echo -e "GRANT NONE TO user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 21ms [clickhouse1] bash# echo -e "GRANT NONE TO user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 149ms [clickhouse1] bash# echo $? 167ms [clickhouse1] 0 168ms [clickhouse1] bash# 169ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user NONE privilege/executing command Nov 13,2025 1:02:36 ⟥ Then check if output has exception 3ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user NONE privilege/check if output has exception 174ms ⟥⟤ OK I grant the user NONE privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user NONE privilege Nov 13,2025 1:02:36 ⟥ When I grant the user USAGE privilege Nov 13,2025 1:02:36 ⟥ By executing command echo -e "GRANT USAGE ON *.* TO user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 21ms [clickhouse1] bash# echo -e "GRANT USAGE ON *.* TO user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 141ms [clickhouse1] bash# echo $? 172ms [clickhouse1] 0 176ms [clickhouse1] bash# 176ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user USAGE privilege/executing command Nov 13,2025 1:02:36 ⟥ Then check if output has exception 525us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user USAGE privilege/check if output has exception 181ms ⟥⟤ OK I grant the user USAGE privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user USAGE privilege Nov 13,2025 1:02:36 ⟥ When I attempt to attach a temporary table without privilege Nov 13,2025 1:02:36 ⟥ By executing command echo -e "ATTACH TEMPORARY TABLE temp_table_user_without_privilege_7188b5d4_c02c_11f0_a220_920006bc6c52 (x Int8)" | clickhouse client -n --user "user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" 2>&1 19ms [clickhouse1] bash# echo -e "ATTACH TEMPORARY TABLE temp_table_user_without_privilege_7188b5d4_c02c_11f0_a220_920006bc6c52 (x Int8)" | clickhouse client -n --user "user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" 2>&1 142ms [clickhouse1] Code: 62. DB::Exception: Syntax error: failed at position 18 (TABLE): TABLE temp_table_user_without_privilege_7188b5d4_c02c_11f0_a220_920006bc6c52 (x Int8) 142ms [clickhouse1] . Expected VIEW. (SYNTAX_ERROR) 142ms [clickhouse1] 161ms [clickhouse1] bash# echo $? 182ms [clickhouse1] 62 196ms [clickhouse1] bash# 197ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I attempt to attach a temporary table without privilege/executing command Nov 13,2025 1:02:36 ⟥ Then exitcode should be 241 19ms ⟥ Exception: Traceback (most recent call last): File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap self._bootstrap_inner() File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner self.run() File "/usr/lib/python3.12/threading.py", line 1010, in run self._target(*self._args, **self._kwargs) File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run result = self.fn(*self.args, **self.kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/attach/attach_temp_table.py", line 170, in feature privilege_granted_directly_or_via_role() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/attach/attach_temp_table.py", line 20, in privilege_granted_directly_or_via_role privilege_check( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/attach/attach_temp_table.py", line 52, in privilege_check node.query( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1189, in query assert r.exitcode == exitcode, error(r.output) ^^^^^^^^^^^^^^^^^^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert r.exitcode == exitcode, error(r.output) Description Code: 62. DB::Exception: Syntax error: failed at position 18 (TABLE): TABLE temp_table_user_without_privilege_7188b5d4_c02c_11f0_a220_920006bc6c52 (x Int8) . Expected VIEW. (SYNTAX_ERROR) Assertion values assert r.exitcode == exitcode, error(r.output) ^ is assert r.exitcode == exitcode, error(r.output) ^ is = 62 assert r.exitcode == exitcode, error(r.output) ^ is 241 assert r.exitcode == exitcode, error(r.output) ^ is = False assert r.exitcode == exitcode, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1189 in 'query' 1181| **kwargs, 1182| ) 1183| 1184| if no_checks: 1185| return r 1186| 1187| if exitcode is not None: 1188| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 1189|> assert r.exitcode == exitcode, error(r.output) 1190| 1191| if message is not None: 1192| with ( 23ms ⟥⟤ Fail exitcode should be 241, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I attempt to attach a temporary table without privilege/exitcode should be 241, AssertionError 222ms ⟥⟤ Fail I attempt to attach a temporary table without privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I attempt to attach a temporary table without privilege, AssertionError Nov 13,2025 1:02:37 ⟥ Finally I drop the temporary table, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:02:37 ⟥ By executing command echo -e "DROP TEMPORARY TABLE IF EXISTS temp_table_user_without_privilege_7188b5d4_c02c_11f0_a220_920006bc6c52" | clickhouse client -n 2>&1 33ms [clickhouse1] bash# echo -e "DROP TEMPORARY TABLE IF EXISTS temp_table_user_without_privilege_7188b5d4_c02c_11f0_a220_920006bc6c52" | clickhouse client -n 2>&1 95ms [clickhouse1] bash# echo $? 95ms [clickhouse1] 0 96ms [clickhouse1] bash# 96ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I drop the temporary table/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 554us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I drop the temporary table/check if output has exception 98ms ⟥⟤ OK I drop the temporary table, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I drop the temporary table 682ms ⟥⟤ Fail user without privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege, AssertionError 686ms ⟥⟤ Fail I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges, AssertionError Nov 13,2025 1:02:37 ⟥ Finally I drop the user, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:02:37 ⟥ By executing command echo -e "DROP USER IF EXISTS user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 16ms [clickhouse1] bash# echo -e "DROP USER IF EXISTS user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 125ms [clickhouse1] bash# echo $? 126ms [clickhouse1] 0 129ms [clickhouse1] bash# 129ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I drop the user/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 832us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I drop the user/check if output has exception 131ms ⟥⟤ OK I drop the user, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege/I drop the user 979ms ⟥⟤ Fail user with direct privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege, AssertionError AssertionError ✘ 1s 386ms [ Fail ] /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role Nov 13,2025 1:02:37 ⟥ Suite user with privilege via role, flags:TE Nov 13,2025 1:02:37 ⟥ Given I have a user, flags:MANDATORY|SETUP Nov 13,2025 1:02:37 ⟥ By executing command echo -e "CREATE USER OR REPLACE user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 5ms [clickhouse1] bash# echo -e "CREATE USER OR REPLACE user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 115ms [clickhouse1] bash# echo $? 116ms [clickhouse1] 0 118ms [clickhouse1] bash# 118ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I have a user/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 743us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I have a user/check if output has exception 120ms ⟥⟤ OK I have a user, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I have a user Nov 13,2025 1:02:37 ⟥ Given I have a role, flags:MANDATORY|SETUP Nov 13,2025 1:02:37 ⟥ By executing command echo -e "CREATE ROLE OR REPLACE role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 43ms [clickhouse1] bash# echo -e "CREATE ROLE OR REPLACE role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 166ms [clickhouse1] bash# echo $? 166ms [clickhouse1] 0 172ms [clickhouse1] bash# 173ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I have a role/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 1ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I have a role/check if output has exception 175ms ⟥⟤ OK I have a role, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I have a role Nov 13,2025 1:02:37 ⟥ When I grant the role to the user Nov 13,2025 1:02:37 ⟥ By executing command echo -e "GRANT role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 TO user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 59ms [clickhouse1] bash# echo -e "GRANT role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 TO user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 156ms [clickhouse1] bash# echo $? 156ms [clickhouse1] 0 157ms [clickhouse1] bash# 158ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I grant the role to the user/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 1ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I grant the role to the user/check if output has exception 161ms ⟥⟤ OK I grant the role to the user, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I grant the role to the user Nov 13,2025 1:02:37 ⟥ When I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges Nov 13,2025 1:02:37 ⟥ Step user without privilege Nov 13,2025 1:02:37 ⟥ When I grant the user NONE privilege Nov 13,2025 1:02:37 ⟥ By executing command echo -e "GRANT NONE TO role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 6ms [clickhouse1] bash# echo -e "GRANT NONE TO role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 86ms [clickhouse1] bash# echo $? 86ms [clickhouse1] 0 87ms [clickhouse1] bash# 87ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user NONE privilege/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 800us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user NONE privilege/check if output has exception 90ms ⟥⟤ OK I grant the user NONE privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user NONE privilege Nov 13,2025 1:02:37 ⟥ When I grant the user USAGE privilege Nov 13,2025 1:02:37 ⟥ By executing command echo -e "GRANT USAGE ON *.* TO role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 6ms [clickhouse1] bash# echo -e "GRANT USAGE ON *.* TO role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 133ms [clickhouse1] bash# echo $? 133ms [clickhouse1] 0 134ms [clickhouse1] bash# 135ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user USAGE privilege/executing command Nov 13,2025 1:02:37 ⟥ Then check if output has exception 759us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user USAGE privilege/check if output has exception 137ms ⟥⟤ OK I grant the user USAGE privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I grant the user USAGE privilege Nov 13,2025 1:02:37 ⟥ When I attempt to attach a temporary table without privilege Nov 13,2025 1:02:37 ⟥ By executing command echo -e "ATTACH TEMPORARY TABLE temp_table_user_without_privilege_724bdc82_c02c_11f0_9dc4_920006bc6c52 (x Int8)" | clickhouse client -n --user "user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" 2>&1 12ms [clickhouse1] bash# echo -e "ATTACH TEMPORARY TABLE temp_table_user_without_privilege_724bdc82_c02c_11f0_9dc4_920006bc6c52 (x Int8)" | clickhouse client -n --user "user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" 2>&1 86ms [clickhouse1] Code: 62. DB::Exception: Syntax error: failed at position 18 (TABLE): TABLE temp_table_user_without_privilege_724bdc82_c02c_11f0_9dc4_920006bc6c52 (x Int8) 108ms [clickhouse1] . Expected VIEW. (SYNTAX_ERROR) 110ms [clickhouse1] 126ms [clickhouse1] bash# echo $? 126ms [clickhouse1] 62 127ms [clickhouse1] bash# 127ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I attempt to attach a temporary table without privilege/executing command Nov 13,2025 1:02:38 ⟥ Then exitcode should be 241 27ms ⟥ Exception: Traceback (most recent call last): File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap self._bootstrap_inner() File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner self.run() File "/usr/lib/python3.12/threading.py", line 1010, in run self._target(*self._args, **self._kwargs) File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run result = self.fn(*self.args, **self.kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/attach/attach_temp_table.py", line 170, in feature privilege_granted_directly_or_via_role() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/attach/attach_temp_table.py", line 32, in privilege_granted_directly_or_via_role privilege_check( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/privileges/attach/attach_temp_table.py", line 52, in privilege_check node.query( File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1189, in query assert r.exitcode == exitcode, error(r.output) ^^^^^^^^^^^^^^^^^^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert r.exitcode == exitcode, error(r.output) Description Code: 62. DB::Exception: Syntax error: failed at position 18 (TABLE): TABLE temp_table_user_without_privilege_724bdc82_c02c_11f0_9dc4_920006bc6c52 (x Int8) . Expected VIEW. (SYNTAX_ERROR) Assertion values assert r.exitcode == exitcode, error(r.output) ^ is assert r.exitcode == exitcode, error(r.output) ^ is = 62 assert r.exitcode == exitcode, error(r.output) ^ is 241 assert r.exitcode == exitcode, error(r.output) ^ is = False assert r.exitcode == exitcode, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1189 in 'query' 1181| **kwargs, 1182| ) 1183| 1184| if no_checks: 1185| return r 1186| 1187| if exitcode is not None: 1188| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 1189|> assert r.exitcode == exitcode, error(r.output) 1190| 1191| if message is not None: 1192| with ( 29ms ⟥⟤ Fail exitcode should be 241, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I attempt to attach a temporary table without privilege/exitcode should be 241, AssertionError 158ms ⟥⟤ Fail I attempt to attach a temporary table without privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I attempt to attach a temporary table without privilege, AssertionError Nov 13,2025 1:02:38 ⟥ Finally I drop the temporary table, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:02:38 ⟥ By executing command echo -e "DROP TEMPORARY TABLE IF EXISTS temp_table_user_without_privilege_724bdc82_c02c_11f0_9dc4_920006bc6c52" | clickhouse client -n 2>&1 54ms [clickhouse1] bash# echo -e "DROP TEMPORARY TABLE IF EXISTS temp_table_user_without_privilege_724bdc82_c02c_11f0_9dc4_920006bc6c52" | clickhouse client -n 2>&1 204ms [clickhouse1] bash# echo $? 205ms [clickhouse1] 0 205ms [clickhouse1] bash# 206ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I drop the temporary table/executing command Nov 13,2025 1:02:38 ⟥ Then check if output has exception 1ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I drop the temporary table/check if output has exception 208ms ⟥⟤ OK I drop the temporary table, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege/I drop the temporary table 597ms ⟥⟤ Fail user without privilege, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges/user without privilege, AssertionError 599ms ⟥⟤ Fail I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I run checks that user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52 with role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52 is only able to execute CREATE TEMPORARY TABLE with required privileges, AssertionError Nov 13,2025 1:02:38 ⟥ Finally I drop the role, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:02:38 ⟥ By executing command echo -e "DROP ROLE IF EXISTS role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 36ms [clickhouse1] bash# echo -e "DROP ROLE IF EXISTS role_privilege_granted_directly_or_via_role_716f6e0a_c02c_11f0_ba47_920006bc6c52" | clickhouse client -n 2>&1 148ms [clickhouse1] bash# echo $? 148ms [clickhouse1] 0 153ms [clickhouse1] bash# 153ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I drop the role/executing command Nov 13,2025 1:02:38 ⟥ Then check if output has exception 683us ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I drop the role/check if output has exception 155ms ⟥⟤ OK I drop the role, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I drop the role Nov 13,2025 1:02:38 ⟥ Finally I drop the user, flags:TE|MANDATORY|CLEANUP Nov 13,2025 1:02:38 ⟥ By executing command echo -e "DROP USER IF EXISTS user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 17ms [clickhouse1] bash# echo -e "DROP USER IF EXISTS user_privilege_granted_directly_or_via_role_716f6f11_c02c_11f0_b2ae_920006bc6c52" | clickhouse client -n 2>&1 120ms [clickhouse1] bash# echo $? 127ms [clickhouse1] 0 134ms [clickhouse1] bash# 139ms ⟥⟤ OK executing command, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I drop the user/executing command Nov 13,2025 1:02:38 ⟥ Then check if output has exception 11ms ⟥⟤ OK check if output has exception, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I drop the user/check if output has exception 165ms ⟥⟤ OK I drop the user, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role/I drop the user 1s 386ms ⟥⟤ Fail user with privilege via role, /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role, AssertionError AssertionError ✘ 2s 566ms [ Fail ] /rbac/part 1/privileges/attach temporary table/privilege granted directly or via role AssertionError ✘ 2s 569ms [ Fail ] /rbac/part 1/privileges/attach temporary table AssertionError ✘ 1m 27s [ Fail ] /rbac/part 1/privileges/create table AssertionError ✘ 21m 45s [ Fail ] /rbac/part 1/privileges AssertionError ✘ 25m 51s [ Fail ] /rbac/part 1 AssertionError ✘ 27m 31s [ Fail ] /rbac AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 437, in regression() File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/regression.py", line 423, in regression Feature(run=load("rbac.tests.syntax.feature", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/feature.py", line 8, in feature Feature(run=load("rbac.tests.syntax.alter_user", "feature")) File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/alter_user.py", line 310, in feature with setup("user15"), setup_role("second"), setup_role("third"): File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../rbac/tests/syntax/alter_user.py", line 31, in setup node.query(f"CREATE USER OR REPLACE {user}") File "/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py", line 1205, in query assert False, error(r.output) ^^^^^ AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 25.11.1): Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: Couldn't delete /var/lib/clickhouse/access/38373166-2d31-6134-6164-373733313063.sql. (FILE_DOESNT_EXIST) (query: CREATE USER OR REPLACE user15 ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/clickhouse-regression/clickhouse-regression/rbac/../helpers/cluster.py', line 1205 in 'query' 1197| assert message in r.output, error(r.output) 1198| 1199| if not ignore_exception: 1200| if message is None or "Exception:" not in message: 1201| with Then("check if output has exception") if steps else NullStep(): 1202| if "Exception:" in r.output: 1203| if raise_on_exception: 1204| raise QueryRuntimeException(r.output) 1205|> assert False, error(r.output) 1206| 1207| return r 1208| Failing ✘ [ Fail ] '/rbac/part 1/syntax/alter user/I alter user default role multiple' (260ms) ✘ [ Fail ] '/rbac/part 1/syntax/alter user' (12s 685ms) ✘ [ Fail ] '/rbac/part 1/syntax/drop row policy/I drop row policy if exists, policy does exist' (199ms) ✘ [ Fail ] '/rbac/part 1/syntax/drop row policy/I drop multiple row policies' (251ms) ✘ [ Fail ] '/rbac/part 1/syntax/drop row policy/I drop row policy on multiple tables' (265ms) ✘ [ Fail ] '/rbac/part 1/syntax/drop row policy/I drop multiple row policies on multiple tables' (450ms) ✘ [ Fail ] '/rbac/part 1/syntax/drop row policy' (3s 705ms) ✘ [ Fail ] '/rbac/part 1/syntax/alter quota/I alter quota keyed by none' (113ms) ✘ [ Fail ] '/rbac/part 1/syntax/alter quota' (5s 816ms) ✘ [ Fail ] '/rbac/part 1/syntax/alter settings profile/I alter settings profile with a setting value' (108ms) ✘ [ Fail ] '/rbac/part 1/syntax/alter settings profile' (5s 243ms) ✘ [ Fail ] '/rbac/part 1/syntax/set default role/I set one default role for user default, throws exception' (109ms) ✘ [ Fail ] '/rbac/part 1/syntax/set default role' (2s 676ms) ✘ [ Fail ] '/rbac/part 1/syntax' (4m 5s) ✘ [ Fail ] '/rbac/part 1/privileges/create table/create as another table' (5s 107ms) ✘ [ Fail ] '/rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with direct privilege' (979ms) ✘ [ Fail ] '/rbac/part 1/privileges/attach temporary table/privilege granted directly or via role/user with privilege via role' (1s 386ms) ✘ [ Fail ] '/rbac/part 1/privileges/attach temporary table/privilege granted directly or via role' (2s 566ms) ✘ [ Fail ] '/rbac/part 1/privileges/attach temporary table' (2s 569ms) ✘ [ Fail ] '/rbac/part 1/privileges/create table' (1m 27s) ✘ [ Fail ] '/rbac/part 1/privileges' (21m 45s) ✘ [ Fail ] '/rbac/part 1' (25m 51s) ✘ [ Fail ] '/rbac' (27m 31s) Debugging Rerun the first failing test by executing your test program with the '--only' option. --only '/rbac/part 1/syntax/alter user/I alter user default role multiple/*' See first failed test messages using the 'tfs show messages' command. tfs show messages --log test.log '/rbac/part 1/syntax/alter user/I alter user default role multiple' Coverage SRS-006 ClickHouse Role Based Access Control 625 requirements (397 satisfied 63.5%, 26 unsatisfied 4.2%, 202 untested 32.3%) 1 module (1 failed) 1291 suites (1286 ok, 3 failed, 2 xfail) 126 features (114 ok, 10 failed, 1 skipped, 1 xfail) 4641 scenarios (4553 ok, 9 failed, 79 xfail) 34 checks (34 ok) 1357 examples (1349 ok, 8 skipped) 14 retries (14 ok) 221050 steps (219666 ok, 267 failed, 1117 xfail) Total time 27m 31s Executed on Nov 13,2025 0:43 TestFlows.com Open-Source Software Testing Framework v2.0.250110.1002922