Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save azat/d377fb50d934d5c2b5b082666f332a53 to your computer and use it in GitHub Desktop.
Save azat/d377fb50d934d5c2b5b082666f332a53 to your computer and use it in GitHub Desktop.
diff --git a/tests/queries/0_stateless/02845_threads_count_in_distributed_queries.sql.j2 b/tests/queries/0_stateless/02845_threads_count_in_distributed_queries.sql.j2
index 1784cc96c97..06a691dc7f4 100644
--- a/tests/queries/0_stateless/02845_threads_count_in_distributed_queries.sql.j2
+++ b/tests/queries/0_stateless/02845_threads_count_in_distributed_queries.sql.j2
@@ -18,7 +18,7 @@ select count() from remote('127.0.0.1:9000', view(
{% for n in range(379) -%}
SELECT * FROM system.one {{ "UNION ALL" if not loop.last }}
{% endfor -%}
- )) SETTINGS log_comment='check_concurrency_in_remote_queries1';
+ )) SETTINGS log_comment='check_concurrency_in_remote_queries1', prefer_localhost_replica=1;
SYSTEM FLUSH LOGS;
@@ -162,7 +162,7 @@ FROM test_lot_of_parts_distributed
WHERE a = 'foo' AND value != '' AND positionCaseInsensitiveUTF8(value, 'baz') > 0 AND b = 'bar' AND c >= _CAST('1683504000', 'DateTime64')
ORDER BY c DESC
LIMIT 5
-SETTINGS log_comment='check_concurrency_in_remote_queries4' FORMAT Null;
+SETTINGS log_comment='check_concurrency_in_remote_queries4', prefer_localhost_replica=1 FORMAT Null;
SYSTEM FLUSH LOGS;
@@ -200,7 +200,7 @@ FROM test_lot_of_parts_distributed
WHERE a = 'foo' AND value != '' AND positionCaseInsensitiveUTF8(value, 'baz') > 0 AND b = 'bar' AND c >= _CAST('1683504000', 'DateTime64')
ORDER BY c DESC
LIMIT 5
-SETTINGS log_comment='check_concurrency_in_remote_queries5', async_socket_for_remote=0 FORMAT Null;
+SETTINGS log_comment='check_concurrency_in_remote_queries5', async_socket_for_remote=0, prefer_localhost_replica=1 FORMAT Null;
SYSTEM FLUSH LOGS;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment