{"action":"opened","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1958","repository_url":"https://api.github.com/repos/MyCATApache/Mycat-Server","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1958/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1958/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1958/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/1958","id":350255036,"node_id":"MDU6SXNzdWUzNTAyNTUwMzY=","number":1958,"title":"1.65  Mysql   对于分区表   Select 语句中的 AS 后面的变量  使用反引号 `  报错","user":{"login":"hanyoubin","id":41186877,"node_id":"MDQ6VXNlcjQxMTg2ODc3","avatar_url":"https://avatars1.githubusercontent.com/u/41186877?v=4","gravatar_id":"","url":"https://api.github.com/users/hanyoubin","html_url":"https://github.com/hanyoubin","followers_url":"https://api.github.com/users/hanyoubin/followers","following_url":"https://api.github.com/users/hanyoubin/following{/other_user}","gists_url":"https://api.github.com/users/hanyoubin/gists{/gist_id}","starred_url":"https://api.github.com/users/hanyoubin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hanyoubin/subscriptions","organizations_url":"https://api.github.com/users/hanyoubin/orgs","repos_url":"https://api.github.com/users/hanyoubin/repos","events_url":"https://api.github.com/users/hanyoubin/events{/privacy}","received_events_url":"https://api.github.com/users/hanyoubin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-14T02:06:02Z","updated_at":"2018-08-14T02:06:02Z","closed_at":null,"author_association":"NONE","body":"对于使用分区的表，\r\n\r\nSELECT  count(1) as `AAA`, location_algorithm_id,time\r\n FROM  `lls_location_result`\r\n WHERE ( `lls_location_result`.`time` BETWEEN '2014-07-09 16:00:00' AND '2014-07-10 16:00:00' )\r\n group by location_algorithm_id, time\r\nORDER BY `time` ASC\r\n\r\n[Err] 1105 - java.lang.NullPointerException\r\n\r\n去掉  AAA 的` 则可以正确执行。\r\n\r\n\r\n对于没有分区的表，(global)  则没有这个问题 \r\n如下SQL可以正常执行，无论是否使用 反引号 `\r\nselect COUNT(1) as 'aaa', last_login, `is_superuser`,`first_name` from application_manager_customuser  group by  `last_login`, `is_superuser`,`first_name`  order by id asc;\r\n"}}
{"actor":{"display_login":"hanyoubin"}}