I identified some myths while working with vacuum command spark 3.5.x.

1. vacuum command is not working with days. Instead it's retain clause is asking explicitly to supply values in hours. I tried many times, and it is throwing parse syntax error (why ???).

2. You cannot execute vacuum command if delta.enableChangeDataFeed is enabled. Because it cannot remove files from _change_data folder if it contains parquet files in it.

So, your table history is not deleted by vacuum command is CDF is enabled.

Let me know if you want to pass me some knowledge on vacuum command. Because I feel it is not doing its work as expected.