Fix missing column definer in system.tables

Algunenano · Algunenano · commit 2bc73cb397d0 · 2025-08-27T18:51:32.000+02:00
diff --git a/src/Storages/System/StorageSystemTables.cpp b/src/Storages/System/StorageSystemTables.cpp
@@ -820,7 +820,10 @@ class TablesBlockSource : public ISource
                         res_columns[res_index++]->insert(dependents_databases);
                     if (columns_mask[src_index++])
                         res_columns[res_index++]->insert(dependents_tables);
-
+                }
+                else
+                {
+                    src_index += 4;
                 }
 
                 if (columns_mask[src_index++])
diff --git a/tests/queries/0_stateless/03602_query_system_tables_definer.reference b/tests/queries/0_stateless/03602_query_system_tables_definer.reference
@@ -0,0 +1 @@
+1
diff --git a/tests/queries/0_stateless/03602_query_system_tables_definer.sql b/tests/queries/0_stateless/03602_query_system_tables_definer.sql
@@ -0,0 +1,2 @@
+-- https://github.com/ClickHouse/ClickHouse/issues/85973#issuecomment-3228974538
+SELECT count() != 0 FROM (Select definer FROM `system`.`tables`);

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- https://github.com/ClickHouse/ClickHouse/issues/85973#issuecomment-3228974538`
	`2`	+SELECT count() != 0 FROM (Select definer FROM `system`.`tables`);