一个查询语句在navicat中可以执行，但是在mybatis中报错了

Question

报错提示的语句和我写的mybatis中的语句不一样，不知道怎么个回事儿0.0。

mybatis中sql语句：

        SELECT
            t.m_id as 'id',
            t.name,
            t.numbers,
            t.s_id as 'spId',
            t.learned,
            t.learning,
            t.plan_finish_date as 'planFinishDate',
            t.plan,
            t.next_plan as 'nextPlan'
        FROM(
            SELECT
                m.id as 'm_id',
                m.name,
                m.createdate,
                s.numbers,
                s.id as 's_id',
                s.learned,
                s.learning,
                s.plan_finish_date ,
                s.plan,
                s.next_plan
            FROM
                member AS m
            LEFT JOIN study_plan AS s ON m.id = s.m_id
            ORDER BY
                s.numbers DESC
            LIMIT 10000
        ) t
        GROUP BY t.name
        ORDER BY t.createdate

我多粘贴了一些报错信息

Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count

xml截个图

Answer 1

你这两个sql也不一样啊