What happens if a product is in multiple registered collections?

The best discount tier from any collection applies (e.g., 20% from Collection A vs. 10% from Collection B).