[procedure] Enhance return result for compact procedure

[Askwang]

Purpose

Linked issue: https://github.com/apache/paimon/issues/5511. The result of compact procedure is true or false in default. For one compact job call, we want to know the detailed results, for example, how many files were deleted and added.

In addition, the compact call may run a empty job and return true, we cannot identify whether the job is a valid compact.

Add compact return result for CALL sys.compact(table => 'T') call.

+------------------+--------------------+-------------+---------------+
|involved_files_num|involved_files_bytes|new_files_num|new_files_bytes|
+------------------+--------------------+-------------+---------------+
|5                 |1440                |1            |308            |
+------------------+--------------------+-------------+---------------+

Tests

API and Format

Documentation