我有文件与sql函数约1k行。Sonar在此文件上抛出错误。代码本身的工作没有错误。下面是请求出错的一般视图。解析错误信息指向符号"^">
INSERT INTO foo
SELECT
...
FROM foo
JOIN ..
JOIN ...
CROSS APPLY (SELECT TOP (1)
...
FROM ...
WHERE ...
ORDER BY ..
UNION
^
SELECT TOP (1)
...
FROM ...
JOIN ...
JOIN ...
WHERE ...
ORDER BY ...
) pp
INSERT INTO foo
SELECT
...
FROM foo
JOIN ..
JOIN ...
CROSS APPLY ((SELECT TOP (1)
...
FROM ...
WHERE ...
ORDER BY ..)
UNION
^
( SELECT TOP (1)
...
FROM ...
JOIN ...
JOIN ...
WHERE ...
ORDER BY ..)
) pp