Skip to content

Commit 43c1ad5

Browse files
rienathrienath
committed
Force random db creation by not creating one explicitly to fix flakiness in parallel runs
1 parent dd3f595 commit 43c1ad5

1 file changed

Lines changed: 8 additions & 10 deletions

File tree

‎tests/queries/0_stateless/03314_insert_select_message.sh‎

Lines changed: 8 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -6,23 +6,21 @@ CUR_DIR=$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)
66

77
# Track degradations for issue https://github.com/ClickHouse/ClickHouse/issues/47800
88

9-
$CLICKHOUSE_CLIENT --query "CREATE DATABASE IF NOT EXISTS test_03314"
10-
$CLICKHOUSE_CLIENT --query "CREATE TABLE IF NOT EXISTS test_03314.table (id UInt64, name String) ENGINE = Memory"
9+
$CLICKHOUSE_CLIENT --query "CREATE TABLE IF NOT EXISTS test (id UInt64, name String) ENGINE = Memory"
1110

1211
# Test 1: INSERT-SELECT (processed_rows_from_progress)
13-
$CLICKHOUSE_CLIENT --processed-rows --query "INSERT INTO test_03314.table SELECT number AS id, toString(number) AS name FROM numbers(100)"
12+
$CLICKHOUSE_CLIENT --processed-rows --query "INSERT INTO test SELECT number AS id, toString(number) AS name FROM numbers(100)"
1413

1514
# Test 2: Large INSERT-SELECT (processed_rows_from_progress)
16-
$CLICKHOUSE_CLIENT --processed-rows --query "INSERT INTO test_03314.table SELECT number AS id, toString(number) AS name FROM numbers(1000000)"
15+
$CLICKHOUSE_CLIENT --processed-rows --query "INSERT INTO test SELECT number AS id, toString(number) AS name FROM numbers(1000000)"
1716

1817
# Test 3: Regular SELECT (processed_rows_from_blocks)
19-
$CLICKHOUSE_CLIENT --processed-rows --query "SELECT * FROM test_03314.table ORDER BY id LIMIT 30"
18+
$CLICKHOUSE_CLIENT --processed-rows --query "SELECT * FROM test ORDER BY id LIMIT 30"
2019

2120
# Test 4: INSERT with Materialized View (to verify we correctly show that data was inserted twice)
22-
$CLICKHOUSE_CLIENT --query "CREATE MATERIALIZED VIEW IF NOT EXISTS test_03314.mv ENGINE = Memory AS SELECT id FROM test_03314.table"
23-
$CLICKHOUSE_CLIENT --processed-rows --query "INSERT INTO test_03314.table SELECT number AS id, toString(number) AS name FROM numbers(50)"
21+
$CLICKHOUSE_CLIENT --query "CREATE MATERIALIZED VIEW IF NOT EXISTS mv ENGINE = Memory AS SELECT id FROM test"
22+
$CLICKHOUSE_CLIENT --processed-rows --query "INSERT INTO test SELECT number AS id, toString(number) AS name FROM numbers(50)"
2423

2524
# Cleanup
26-
$CLICKHOUSE_CLIENT --query "DROP VIEW IF EXISTS test_03314.mv"
27-
$CLICKHOUSE_CLIENT --query "DROP TABLE IF EXISTS test_03314.table"
28-
$CLICKHOUSE_CLIENT --query "DROP DATABASE IF EXISTS test_03314"
25+
$CLICKHOUSE_CLIENT --query "DROP VIEW IF EXISTS mv"
26+
$CLICKHOUSE_CLIENT --query "DROP TABLE IF EXISTS test"

0 commit comments

Comments
 (0)