{"action":"opened","issue":{"url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/652","repository_url":"https://api.github.com/repos/baomidou/mybatis-plus","labels_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/652/labels{/name}","comments_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/652/comments","events_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/652/events","html_url":"https://github.com/baomidou/mybatis-plus/issues/652","id":384734291,"node_id":"MDU6SXNzdWUzODQ3MzQyOTE=","number":652,"title":"当条件查询为空时，执行ordeBy 报错","user":{"login":"accpman","id":4446237,"node_id":"MDQ6VXNlcjQ0NDYyMzc=","avatar_url":"https://avatars3.githubusercontent.com/u/4446237?v=4","gravatar_id":"","url":"https://api.github.com/users/accpman","html_url":"https://github.com/accpman","followers_url":"https://api.github.com/users/accpman/followers","following_url":"https://api.github.com/users/accpman/following{/other_user}","gists_url":"https://api.github.com/users/accpman/gists{/gist_id}","starred_url":"https://api.github.com/users/accpman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/accpman/subscriptions","organizations_url":"https://api.github.com/users/accpman/orgs","repos_url":"https://api.github.com/users/accpman/repos","events_url":"https://api.github.com/users/accpman/events{/privacy}","received_events_url":"https://api.github.com/users/accpman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-27T10:51:06Z","updated_at":"2018-11-27T10:51:06Z","closed_at":null,"author_association":"NONE","body":"### 当前使用版本3.0.6(必须填写清楚，否则不予处理)\r\n\r\n\r\n### 该问题是怎么引起的？**(注意!!!请使用最新版(具体版本查看CHANGELOG.md),如还有该问题再提 issue!,否则直接拒绝,毫不商量!!!)**\r\n\r\nareaId 和areaName为空时执行order报错\r\n\r\n### 重现步骤\r\nString areaId = ObjectUtils.getParameter(\"areaId\", \"\");\r\nString areaName = ObjectUtils.getParameter(\"areaName\");\r\nMyQueryWrapper<EntityMap> qw = new MyQueryWrapper<EntityMap>(pagerInfo);\r\nqw.eq(false,\"a.id\", areaId);\r\nqw.eq(false,\"a.areaName\", areaName);\r\nqw.orderBy(false,false,\"a.id\");\r\nreturn bizService.pageList(qw);\r\n### 报错信息\r\nsql最后片段多了一个whereFROM t_u_accountinfo as ai left join t_u_account account on account.id = ai.id WHERE ORDER BY account.id ASC ) TOTAL\r\nError: Method queryTotal execution error.\r\n\r\n"}}
{"actor":{"display_login":"accpman"}}