C#项目调试接口，报错Access violation，直接终止

1. 可能原因：堆栈溢出

• 业务场景：根据三级Id获取一级数据
• 实现：SQL语句渐进式推进

SELECT
	a.Id,
	a.NAME,
	a.CODE,
	a.ParentId,
	1 AS LEVEL 
FROM
	table a //一级
	LEFT JOIN table b ON b.ParentId = a.Id //二级
	LEFT JOIN table c ON c.ParentId = b.Id //三级
WHERE
	c.Id = @Id 
	AND a.Deleted = 0 
	AND b.Deleted = 0 
	AND c.Deleted = 0

• 调试时直接终止程序，报错Access violation
• 调整SQL

SELECT
	c.Id,
	c.CODE,
	c.`Name`,
	c.ParentId,
	1 AS LEVEL 
FROM
	table a //三级
	LEFT JOIN table b ON a.ParentId = b.Id //二级
	LEFT JOIN table c ON b.ParentId = c.Id //一级
WHERE
	a.Id = '2d46668b-c279-11ea-8c8a-8c04baa4c044' 
	AND a.Deleted = 0 
	AND a.AgmachineCategory = 1

• 程序正常执行，返回相应数据
• 问题原因哪位大佬还有其他见解的，欢迎指正ヽ(￣▽￣)و