{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/vscode-mssql/issues/418","repository_url":"https://api.github.com/repos/Microsoft/vscode-mssql","labels_url":"https://api.github.com/repos/Microsoft/vscode-mssql/issues/418/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/vscode-mssql/issues/418/comments","events_url":"https://api.github.com/repos/Microsoft/vscode-mssql/issues/418/events","html_url":"https://github.com/Microsoft/vscode-mssql/issues/418","id":191864245,"number":418,"title":"Support for Assemblies/CLR Functions from local file system","user":{"login":"wbuchanan","id":5542790,"avatar_url":"https://avatars.githubusercontent.com/u/5542790?v=3","gravatar_id":"","url":"https://api.github.com/users/wbuchanan","html_url":"https://github.com/wbuchanan","followers_url":"https://api.github.com/users/wbuchanan/followers","following_url":"https://api.github.com/users/wbuchanan/following{/other_user}","gists_url":"https://api.github.com/users/wbuchanan/gists{/gist_id}","starred_url":"https://api.github.com/users/wbuchanan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wbuchanan/subscriptions","organizations_url":"https://api.github.com/users/wbuchanan/orgs","repos_url":"https://api.github.com/users/wbuchanan/repos","events_url":"https://api.github.com/users/wbuchanan/events{/privacy}","received_events_url":"https://api.github.com/users/wbuchanan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"erickangMSFT","id":11077282,"avatar_url":"https://avatars.githubusercontent.com/u/11077282?v=3","gravatar_id":"","url":"https://api.github.com/users/erickangMSFT","html_url":"https://github.com/erickangMSFT","followers_url":"https://api.github.com/users/erickangMSFT/followers","following_url":"https://api.github.com/users/erickangMSFT/following{/other_user}","gists_url":"https://api.github.com/users/erickangMSFT/gists{/gist_id}","starred_url":"https://api.github.com/users/erickangMSFT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erickangMSFT/subscriptions","organizations_url":"https://api.github.com/users/erickangMSFT/orgs","repos_url":"https://api.github.com/users/erickangMSFT/repos","events_url":"https://api.github.com/users/erickangMSFT/events{/privacy}","received_events_url":"https://api.github.com/users/erickangMSFT/received_events","type":"User","site_admin":false},"assignees":[{"login":"erickangMSFT","id":11077282,"avatar_url":"https://avatars.githubusercontent.com/u/11077282?v=3","gravatar_id":"","url":"https://api.github.com/users/erickangMSFT","html_url":"https://github.com/erickangMSFT","followers_url":"https://api.github.com/users/erickangMSFT/followers","following_url":"https://api.github.com/users/erickangMSFT/following{/other_user}","gists_url":"https://api.github.com/users/erickangMSFT/gists{/gist_id}","starred_url":"https://api.github.com/users/erickangMSFT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erickangMSFT/subscriptions","organizations_url":"https://api.github.com/users/erickangMSFT/orgs","repos_url":"https://api.github.com/users/erickangMSFT/repos","events_url":"https://api.github.com/users/erickangMSFT/events{/privacy}","received_events_url":"https://api.github.com/users/erickangMSFT/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-11-27T14:28:27Z","updated_at":"2016-11-29T18:26:56Z","closed_at":null,"body":"- MSSQL Extension Version: 0.1.5 \r\n- VSCode Version: 1.7.2\r\n- OS Version: 10.12.1 (16B2555)\r\n\r\nSteps to Reproduce:\r\n\r\n1. Cloned existing code/assemblies used for [CLR Functions for Regular Expressions and String Distances](https://github.com/wbuchanan/whyWontSQLServerImplementRegexNatively)\r\n\r\n```\r\ncd ~/Desktop/Programs/SQL && git clone https://github.com/wbuchanan/whyWontSQLServerImplementRegexNatively sqlregex\r\n```\r\n\r\n2. Attempted to create an assembly from the local copy of the source referenced above:\r\n\r\n```SQL \r\nCREATE ASSEMBLY SQLServerRegEx\r\nFROM /Users/billy/Desktop/Programs/SQL/sqlregex/SQLServerRegEx/bin/Release/SQLServerRegEx.dll\r\nWITH PERMISSION_SET = EXTERNAL_ACCESS;\r\n```\r\n\r\n3. Results in:\r\n\r\n```\r\n\r\n[9:20:38 AM]\tStarted executing query at Line 1\r\nMsg 102, Level 15, State 1, Line 2 Incorrect syntax near '/'.\r\nMsg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.\r\nTotal execution time: 00:00:00.144\r\n```\r\n\r\nSeems there is some issue with handling the file path delimiters.  It'd be nice to be able to load assemblies from OSX - particularly if people are already developing in C#/Visual Basic.\r\n"},"comment":{"url":"https://api.github.com/repos/Microsoft/vscode-mssql/issues/comments/263655056","html_url":"https://github.com/Microsoft/vscode-mssql/issues/418#issuecomment-263655056","issue_url":"https://api.github.com/repos/Microsoft/vscode-mssql/issues/418","id":263655056,"user":{"login":"kevcunnane","id":10819925,"avatar_url":"https://avatars.githubusercontent.com/u/10819925?v=3","gravatar_id":"","url":"https://api.github.com/users/kevcunnane","html_url":"https://github.com/kevcunnane","followers_url":"https://api.github.com/users/kevcunnane/followers","following_url":"https://api.github.com/users/kevcunnane/following{/other_user}","gists_url":"https://api.github.com/users/kevcunnane/gists{/gist_id}","starred_url":"https://api.github.com/users/kevcunnane/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kevcunnane/subscriptions","organizations_url":"https://api.github.com/users/kevcunnane/orgs","repos_url":"https://api.github.com/users/kevcunnane/repos","events_url":"https://api.github.com/users/kevcunnane/events{/privacy}","received_events_url":"https://api.github.com/users/kevcunnane/received_events","type":"User","site_admin":false},"created_at":"2016-11-29T18:26:56Z","updated_at":"2016-11-29T18:26:56Z","body":"@wbuchanan yes, are far as I know Windows SQL Server requires Windows-style path delimiters, especially older server versions. \r\nSQL Server vNext will work to support Linux-style paths though in its current preview it also expects C: to start paths. In the future, it's likely that you should use the platform-native path syntax, e.g. for Windows C:\\ path format will continue to be required."}}
{"actor":{"display_login":"kevcunnane"}}