{"action":"created","issue":{"url":"https://api.github.com/repos/idies/SkyServer/issues/50","labels_url":"https://api.github.com/repos/idies/SkyServer/issues/50/labels{/name}","comments_url":"https://api.github.com/repos/idies/SkyServer/issues/50/comments","events_url":"https://api.github.com/repos/idies/SkyServer/issues/50/events","html_url":"https://github.com/idies/SkyServer/issues/50","id":96860993,"number":50,"title":"adding a newline between SELECT and TOP causes query to be incorrectly parsed","user":{"login":"capnsue","id":6115950,"avatar_url":"https://avatars.githubusercontent.com/u/6115950?v=3","gravatar_id":"","url":"https://api.github.com/users/capnsue","html_url":"https://github.com/capnsue","followers_url":"https://api.github.com/users/capnsue/followers","following_url":"https://api.github.com/users/capnsue/following{/other_user}","gists_url":"https://api.github.com/users/capnsue/gists{/gist_id}","starred_url":"https://api.github.com/users/capnsue/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/capnsue/subscriptions","organizations_url":"https://api.github.com/users/capnsue/orgs","repos_url":"https://api.github.com/users/capnsue/repos","events_url":"https://api.github.com/users/capnsue/events{/privacy}","received_events_url":"https://api.github.com/users/capnsue/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/idies/SkyServer/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/idies/SkyServer/labels/sciserver_v1_0_0","name":"sciserver_v1_0_0","color":"fef2c0"},{"url":"https://api.github.com/repos/idies/SkyServer/labels/sciserver_v1_0_1","name":"sciserver_v1_0_1","color":"207de5"}],"state":"closed","locked":false,"assignee":{"login":"capnsue","id":6115950,"avatar_url":"https://avatars.githubusercontent.com/u/6115950?v=3","gravatar_id":"","url":"https://api.github.com/users/capnsue","html_url":"https://github.com/capnsue","followers_url":"https://api.github.com/users/capnsue/followers","following_url":"https://api.github.com/users/capnsue/following{/other_user}","gists_url":"https://api.github.com/users/capnsue/gists{/gist_id}","starred_url":"https://api.github.com/users/capnsue/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/capnsue/subscriptions","organizations_url":"https://api.github.com/users/capnsue/orgs","repos_url":"https://api.github.com/users/capnsue/repos","events_url":"https://api.github.com/users/capnsue/events{/privacy}","received_events_url":"https://api.github.com/users/capnsue/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/idies/SkyServer/milestones/1","html_url":"https://github.com/idies/SkyServer/milestones/SciServer_v1_1_0","labels_url":"https://api.github.com/repos/idies/SkyServer/milestones/1/labels","id":1182933,"number":1,"title":"SciServer_v1_1_0","description":"Should be fixed for our public release, currently planned for 8/28/2014","creator":{"login":"raddick","id":1709156,"avatar_url":"https://avatars.githubusercontent.com/u/1709156?v=3","gravatar_id":"","url":"https://api.github.com/users/raddick","html_url":"https://github.com/raddick","followers_url":"https://api.github.com/users/raddick/followers","following_url":"https://api.github.com/users/raddick/following{/other_user}","gists_url":"https://api.github.com/users/raddick/gists{/gist_id}","starred_url":"https://api.github.com/users/raddick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raddick/subscriptions","organizations_url":"https://api.github.com/users/raddick/orgs","repos_url":"https://api.github.com/users/raddick/repos","events_url":"https://api.github.com/users/raddick/events{/privacy}","received_events_url":"https://api.github.com/users/raddick/received_events","type":"User","site_admin":false},"open_issues":15,"closed_issues":7,"state":"open","created_at":"2015-06-26T17:18:13Z","updated_at":"2015-07-23T17:39:46Z","due_on":"2015-08-28T04:00:00Z","closed_at":null},"comments":5,"created_at":"2015-07-23T17:16:18Z","updated_at":"2015-07-23T17:47:57Z","closed_at":"2015-07-23T17:39:46Z","body":"in sql_search:\r\n\r\ntyping the following\r\nSELECT \r\nTOP 10 *\r\nFROM PhotoObj\r\n\r\ncauses query to fail with error message \r\n\r\nMsg 156, Level 15, State 1, Line 15\r\nIncorrect syntax near the keyword 'top'.\r\n\r\nThis is because spExecuteSQL is rewriting the statement as \r\nselect  top 500000 \r\ntop 10 * \r\nfrom photoobj \r\n\r\nIt seems that the parser in spExecuteSQL is ignoring the \"top\" in the original query and adding another one\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/idies/SkyServer/issues/comments/124179024","html_url":"https://github.com/idies/SkyServer/issues/50#issuecomment-124179024","issue_url":"https://api.github.com/repos/idies/SkyServer/issues/50","id":124179024,"user":{"login":"capnsue","id":6115950,"avatar_url":"https://avatars.githubusercontent.com/u/6115950?v=3","gravatar_id":"","url":"https://api.github.com/users/capnsue","html_url":"https://github.com/capnsue","followers_url":"https://api.github.com/users/capnsue/followers","following_url":"https://api.github.com/users/capnsue/following{/other_user}","gists_url":"https://api.github.com/users/capnsue/gists{/gist_id}","starred_url":"https://api.github.com/users/capnsue/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/capnsue/subscriptions","organizations_url":"https://api.github.com/users/capnsue/orgs","repos_url":"https://api.github.com/users/capnsue/repos","events_url":"https://api.github.com/users/capnsue/events{/privacy}","received_events_url":"https://api.github.com/users/capnsue/received_events","type":"User","site_admin":false},"created_at":"2015-07-23T17:47:57Z","updated_at":"2015-07-23T17:47:57Z","body":"I'll def include this fix in the patch for the production sites."}}