I had the problem with our own data, but the problem is very difficult to reproduce with demo data, since it depends on the ordering behaviour of the database.
It is however very clear that UNION does not guarantee to preserve order (as explained in the link I provided above, so there are situations where the start and end date will be reversed.
Hello,
I had the problem with our own data, but the problem is very difficult to reproduce with demo data, since it depends on the ordering behaviour of the database.
It is however very clear that UNION does not guarantee to preserve order (as explained in the link I provided above, so there are situations where the start and end date will be reversed.
Best regards,
-sbi