more stateless test case
@@ -267,8 +267,25 @@ select segment_count, block_count from fuse_snapshot('db_09_0008', 't2') limit 1
----
2 4
+statement ok
+optimize table t2 compact segment limit 2;
+
+statement query II
+select segment_count, block_count from fuse_snapshot('db_09_0008', 't2') limit 1;
+
+----
+1 4
+statement ok
+optimize table t2 compact segment limit 2;
+
+statement query II
+select segment_count, block_count from fuse_snapshot('db_09_0008', 't2') limit 10000;
+
+----
+1 4
+
statement ok
DROP TABLE m;
