为什么“服务器在编译时遇到堆栈溢出”错误是SQL server 2000 Sp4

尝试并优化您的和/或条件。

SELECT * FROM foo
WHERE ([fooKey] = 1 AND Year = 1995)
OR ([fooKey] = 1 AND Year = 1996)
OR ([fooKey] = 1 AND Year = 1997)
OR ([fooKey] = 1 AND Year = 1998)
OR ([fooKey] = 1 AND Year = 1999)
OR ([fooKey] = 1 AND Year = 2000)
OR ([fooKey] = 1 AND Year = 2001)
OR ([fooKey] = 1 AND Year = 2002)
... ad infinitum

变成

SELECT * FROM fooWHERE ([fooKey] = 1 AND Year between 1995 and 2002)
union
SELECT * FROM fooWHERE ([fooKey] = 10017 AND Year = 1995)
union
SELECT * FROM fooWHERE ([fooKey] = 10018 AND Year = 1997)
... slightly less

有趣的虫子!最明显的问题是, 为什么? 堆栈溢出是因为递归是解析这样的SQL语句的典型方式,它构建了一个语法树。根据每次递归调用推送到堆栈上的内容,这并不奇怪。它伤害了服务器吗?;)