这算是个BUG吧？请管理大神鉴定下

风卓羽

这算不算是个BUG，获取total应该是取得记录总数才对啊，怎么取了这么个值？这个值是styleCode 列的值，我用的自定义action sqlQuery
整个的SQL查询语句如下

1. SELECT
   
2. t.styleCode AS styleCode,
   
3. t.styleName AS styleName,
   
4. t.styleTypeID AS styleTypeID,
   
5. t.styleStatus AS styleStatus,
   
6. t.styleColor AS styleColor,
   
7. t.styleSize AS styleSize,
   
8. t.styleImage AS styleImage,
   
9. t.styleDemo AS styleDemo,
   
10. t.styleExtraName AS styleExtraName,
    
11. t.hasItem AS hasItem,
    
12. t.labelName AS labelName,
    
13. t.labeltype AS labeltype,
    
14. t.labelID AS labelID,
    
15. FROM (SELECT
    
16. s.styleCode AS styleCode,
    
17. s.styleName AS styleName,
    
18. s.styleTypeID AS styleTypeID,
    
19. s.styleStatus AS styleStatus,
    
20. s.styleImage AS styleImage,
    
21. s.styleDemo AS styleDemo,
    
22. s.styleColor AS styleColor,
    
23. s.styleSize AS styleSize,
    
24. s.hasItem AS hasItem,
    
25. s.styleExtraName AS styleExtraName,
    
26. GROUP_CONCAT(l.labelName SEPARATOR " ") AS labelName,
    
27. GROUP_CONCAT(l.labeltype SEPARATOR " ") AS labeltype,
    
28. GROUP_CONCAT(l.id SEPARATOR " ") AS labelID
    
29. FROM
    
30. mstyle AS s
    
31. LEFT JOIN mstyle_label AS sl ON s.styleCode = sl.styleCode
    
32. LEFT JOIN mlabel AS l ON sl.labelID = l.id
    
33. GROUP BY
    
34. s.styleCode,
    
35. s.styleName,
    
36. s.styleTypeID,
    
37. s.styleStatus,
    
38. s.styleImage,
    
39. s.styleDemo,
    
40. s.styleColor,
    
41. s.styleSize,
    
42. s.hasItem,
    
43. s.styleExtraName
    
44. ) AS t
    
45. WHERE
    
46. 1=1

复制代码

风卓羽

我找到原因了，还是对这个自定义sql不熟悉，countSQL那里设置的不对，已经解决了