I'm trying to understand the expand on clause.
This one expands to 3 rows:
SEL prd FROM any_table_with_only_1_row EXPAND ON PERIOD'(2020-09-30,2023-09-29)' AS prd BY ANCHOR PERIOD Year_End
This one expands to 4 rows:
SEL prd FROM any_table_with_only_1_row EXPAND ON PERIOD'(2020-09-29,2023-09-28)' AS prd BY ANCHOR PERIOD Year_End
Why do they behave differently?