Fix test

kssenii · kssenii · commit 619f60b5ac17 · 2024-10-14T10:42:32.000+02:00
diff --git a/tests/integration/test_storage_s3/test.py b/tests/integration/test_storage_s3/test.py
@@ -2428,14 +2428,15 @@ def test_filesystem_cache(started_cluster):
         )
     )
 
+    instance.query("SYSTEM DROP SCHEMA CACHE")
+
     query_id = f"{table_name}-{uuid.uuid4()}"
     instance.query(
         f"select * from s3('http://{started_cluster.minio_host}:{started_cluster.minio_port}/{bucket}/{table_name}.tsv') SETTINGS filesystem_cache_name = 'cache1', enable_filesystem_cache=1",
         query_id=query_id,
     )
 
     instance.query("SYSTEM FLUSH LOGS")
-    instance.query("SYSTEM DROP SCHEMA CACHE")
 
     assert count * 2 == int(
         instance.query(

Original file line number	Diff line number	Diff line change
`@@ -2428,14 +2428,15 @@ def test_filesystem_cache(started_cluster):`
`2428`	`2428`	`)`
`2429`	`2429`	`)`
`2430`	`2430`
	`2431`	`+ instance.query("SYSTEM DROP SCHEMA CACHE")`
	`2432`	`+`
`2431`	`2433`	`query_id = f"{table_name}-{uuid.uuid4()}"`
`2432`	`2434`	`instance.query(`
`2433`	`2435`	`f"select * from s3('http://{started_cluster.minio_host}:{started_cluster.minio_port}/{bucket}/{table_name}.tsv') SETTINGS filesystem_cache_name = 'cache1', enable_filesystem_cache=1",`
`2434`	`2436`	`query_id=query_id,`
`2435`	`2437`	`)`
`2436`	`2438`
`2437`	`2439`	`instance.query("SYSTEM FLUSH LOGS")`
`2438`		`- instance.query("SYSTEM DROP SCHEMA CACHE")`
`2439`	`2440`
`2440`	`2441`	`assert count * 2 == int(`
`2441`	`2442`	`instance.query(`