minidao-pe-1.6-20170803.083348-9 版本升级问题
minidao-pe-1.6-20170803.083348-9 这个版本升级后，原本可执行的sql报错。报错如下：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tmp_count' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tmp_count' at line 1。
报错sql（此sql应该是分页时，mimdao做的拼接）：
select
count(0)
from
(SELECT
p.id,
p.person_info_code personInfoCode,
p.name displayName,
p.account_name sAMAccountName
FROM
r_person_info p
WHERE
p.person_info_code IN (
SELECT
DISTINCT b1.person_info_code
FROM
r_person_info b1
left join
r_work_experience b2
on b1.person_info_code=b2.person_info_code
left join
r_professional_skill b3
on b1.person_info_code=b3.person_info_code
where
b1.resume_input_type='portal'
) tmp_count
前一版本minidao-pe-1.6-20170803.083348-8可执行的正常sql（此sql应该是分页时，mimdao做的拼接）：
select
count(0)
from
(SELECT
p.id,
p.person_info_code personInfoCode,
p.name displayName,
p.account_name sAMAccountName
FROM
r_person_info p
WHERE
p.person_info_code IN (
SELECT
DISTINCT b1.person_info_code
FROM
r_person_info b1
left join
r_work_experience b2
on b1.person_info_code=b2.person_info_code
left join
r_professional_skill b3
on b1.person_info_code=b3.person_info_code
where
b1.resume_input_type='portal'
ORDER BY
b1.account_name DESC
)
GROUP BY
p.person_info_code) tmp_count
请查验。
页:
[1]