使用mybatis查出数据与mysql查出来的不一致(order by)_2020-10-23解决的BUG

使用mybatis查出数据与mysql查出来的不一致(order by)_2020-10-23解决的BUG

错误：
xml拼接sql:
select consequence.* from consequence
<where>
    <include refid="getPageCondition"/>
</where>
<if test="page != null and page.orderBy != null and page.orderBy !=''">
    order by #{page.orderBy}
</if>
<include refid="order_by_sql"></include>
<include refid="pageLimit"/>

控制台输出的查询信息：
select consequence.* from consequence WHERE consequence.id < ? and consequence.task_id = ? order by ? limit ? ,?
Parameters: 170166(Long), 99(Long),  id desc (String), 0(Integer), 1(Integer)

在mysql中执行的sql:
SELECT
                consequence.* 
        FROM
                consequence 
        WHERE
                consequence.id < 170166
                AND consequence.task_id = 99
                order by 'id' 'desc'
                LIMIT 0, 1



正确：
xml拼接sql:
select consequence.* from consequence
<where>
    <include refid="getPageCondition"/>
</where>
<if test="page != null and page.orderBy != null and page.orderBy !=''">
    order by ${page.orderBy}
</if>
<include refid="order_by_sql"></include>
<include refid="pageLimit"/>

控制台输出的查询信息:
select consequence.* from consequence WHERE consequence.id < ? and consequence.task_id = ? order by id desc limit ? ,? 
Parameters: 170166(Long), 99(Long), 0(Integer), 1(Integer)

mysql中执行的sql：
SELECT
                consequence.* 
        FROM
                consequence 
        WHERE
                consequence.id < 170166
                AND consequence.task_id = 99
                order by id desc
                LIMIT 0, 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

参考文章