mysql语句在DBeaver和sqlyong中都是可以执行的,但是在mybatis中就会报错?

SELECT

A.*,B.*

FROM

(SELECT

STR_TO_DATE( CONCAT( "2021-06", '-', d ), '%Y-%m-%d' ) AS DATE
FROM
(
SELECT
1 AS d UNION ALL
SELECT
2 UNION ALL
SELECT
3 UNION ALL
SELECT
4 UNION ALL
SELECT
5 UNION ALL
SELECT
6 UNION ALL
SELECT
7 UNION ALL
SELECT
8 UNION ALL
SELECT
9 UNION ALL
SELECT
10 UNION ALL
SELECT
11 UNION ALL
SELECT
12 UNION ALL
SELECT
13 UNION ALL
SELECT
14 UNION ALL
SELECT
15 UNION ALL
SELECT
16 UNION ALL
SELECT
17 UNION ALL
SELECT
18 UNION ALL
SELECT
19 UNION ALL
SELECT
20 UNION ALL
SELECT
21 UNION ALL
SELECT
22 UNION ALL
SELECT
23 UNION ALL
SELECT
24 UNION ALL
SELECT
25 UNION ALL
SELECT
26 UNION ALL
SELECT
27 UNION ALL
SELECT
28 UNION ALL
SELECT
29 UNION ALL
SELECT
30 UNION ALL
SELECT
31
) AS d) A
LEFT JOIN
(SELECT

A.id,A.fk_model_id,A.duty_dates,A.duty_member_ids,B.squad_leader,B.user_night

FROM

ec_duty_model AS B
LEFT JOIN
(SELECT
*

FROM

ec_duty

WHERE

duty_dates IN (SELECT CONCAT('2021-06','-',help_topic_id +1)  DAY

FROM mysql.help_topic
WHERE help_topic_id < DAY(LAST_DAY(CONCAT('2021-06','-1')))
ORDER BY help_topic_id)) AS A
ON A.fk_model_id = B.id AND B.is_delete = 0 AND A.is_delete = 0) AS B
ON DATE = B.duty_dates

这是报错信息
image.png
image.png

阅读 1.5k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题