mysql - 查找重叠日期给无限循环 MySQL

Question

假设我有一张给定日期的表:

+-----------+-----------+----+
|StartDate  |EndDate    |ID  |
+-----------+-----------+----+
|2013-08-29 |2014-12-29 |1   |
|2013-08-29 |2013-09-31 |2   |
|2015-01-02 |2015-03-20 |3   |
+-----------+-----------+----+

我想找到冲突的日期，所以代码应该给我 1 作为冲突的日期。当我在 MySQL 中编写这段代码时，它进入了一个无限循环，我希望能得到一点帮助，因为我看不出为什么它不起作用:

select t1.* from dates t1
inner join dates t2
on t2.StartDate > t1.StartDate
and t2.StartDate < t1.EndDate;

谢谢。

Answer 1

不应该吗？:

select t1.*, t2.id as conflict_id
from dates t1
inner join dates t2
on t2.StartDate >= t1.StartDate
and t2.EndDate <= t1.EndDate
and t2.id != t1.id