--- test flush_region and compact_region ---
CREATE TABLE my_table (
  a INT PRIMARY KEY,
  b STRING,
  ts TIMESTAMP TIME INDEX,
)
PARTITION ON COLUMNS (a) ();

Affected Rows: 0

INSERT INTO my_table VALUES
    (1, 'a', 1),
    (2, 'b', 2),
    (11, 'c', 3),
    (12, 'd', 4),
    (21, 'e', 5),
    (22, 'f', 5);

Affected Rows: 6

SELECT * FROM my_table;

+----+---+-------------------------+
| a  | b | ts                      |
+----+---+-------------------------+
| 1  | a | 1970-01-01T00:00:00.001 |
| 2  | b | 1970-01-01T00:00:00.002 |
| 11 | c | 1970-01-01T00:00:00.003 |
| 12 | d | 1970-01-01T00:00:00.004 |
| 21 | e | 1970-01-01T00:00:00.005 |
| 22 | f | 1970-01-01T00:00:00.005 |
+----+---+-------------------------+

SELECT flush_region(greptime_partition_id) from information_schema.partitions WHERE table_name = 'my_table';

+-------------------------------------------------------------------+
| flush_region(information_schema.partitions.greptime_partition_id) |
+-------------------------------------------------------------------+
| 0                                                                 |
+-------------------------------------------------------------------+

SELECT compact_region(greptime_partition_id) from information_schema.partitions WHERE table_name = 'my_table';

+---------------------------------------------------------------------+
| compact_region(information_schema.partitions.greptime_partition_id) |
+---------------------------------------------------------------------+
| 0                                                                   |
+---------------------------------------------------------------------+

SELECT * FROM my_table;

+----+---+-------------------------+
| a  | b | ts                      |
+----+---+-------------------------+
| 1  | a | 1970-01-01T00:00:00.001 |
| 2  | b | 1970-01-01T00:00:00.002 |
| 11 | c | 1970-01-01T00:00:00.003 |
| 12 | d | 1970-01-01T00:00:00.004 |
| 21 | e | 1970-01-01T00:00:00.005 |
| 22 | f | 1970-01-01T00:00:00.005 |
+----+---+-------------------------+

DROP TABLE my_table;

Affected Rows: 0