{"action":"created","issue":{"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/764","repository_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator","labels_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/764/labels{/name}","comments_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/764/comments","events_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/764/events","html_url":"https://github.com/fluentmigrator/fluentmigrator/issues/764","id":197737067,"number":764,"title":"Issue on CreateIndex VersionInfo with non-default schema","user":{"login":"sindrunas","id":21954787,"avatar_url":"https://avatars3.githubusercontent.com/u/21954787?v=4","gravatar_id":"","url":"https://api.github.com/users/sindrunas","html_url":"https://github.com/sindrunas","followers_url":"https://api.github.com/users/sindrunas/followers","following_url":"https://api.github.com/users/sindrunas/following{/other_user}","gists_url":"https://api.github.com/users/sindrunas/gists{/gist_id}","starred_url":"https://api.github.com/users/sindrunas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sindrunas/subscriptions","organizations_url":"https://api.github.com/users/sindrunas/orgs","repos_url":"https://api.github.com/users/sindrunas/repos","events_url":"https://api.github.com/users/sindrunas/events{/privacy}","received_events_url":"https://api.github.com/users/sindrunas/received_events","type":"User","site_admin":false},"labels":[{"id":133767,"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/labels/Bug","name":"Bug","color":"e10c02","default":false},{"id":885978253,"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/labels/db:oracle","name":"db:oracle","color":"acef75","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/milestones/24","html_url":"https://github.com/fluentmigrator/fluentmigrator/milestone/24","labels_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/milestones/24/labels","id":3226840,"number":24,"title":"2.0.0","description":"# New features\r\n\r\n- Using the .NET Core CLI tooling\r\n- .NET Standard 2.0 support\r\n- .NET Framework 4.5 support\r\n- SQL Anywhere 16 support\r\n- SQL Server 2016 support\r\n... and many more\r\n\r\n# Breaking changes\r\n\r\n- Removal of deprecated functions\r\n- Moving database specific code from `FluentMigrator.Runner` to `FluentMigrator.Runner.<Database>`\r\n- `FluentMigrator` is now `FluentMigrator.Core`\r\n- Removal of .NET Framework 3.5 support\r\n- Removal of NAnt build task\r\n- MSBuild task is available as separate package (with custom .targets file)\r\n- Removal of SchemaDump and T4 experiments\r\n","creator":{"login":"fubar-coder","id":4739844,"avatar_url":"https://avatars3.githubusercontent.com/u/4739844?v=4","gravatar_id":"","url":"https://api.github.com/users/fubar-coder","html_url":"https://github.com/fubar-coder","followers_url":"https://api.github.com/users/fubar-coder/followers","following_url":"https://api.github.com/users/fubar-coder/following{/other_user}","gists_url":"https://api.github.com/users/fubar-coder/gists{/gist_id}","starred_url":"https://api.github.com/users/fubar-coder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fubar-coder/subscriptions","organizations_url":"https://api.github.com/users/fubar-coder/orgs","repos_url":"https://api.github.com/users/fubar-coder/repos","events_url":"https://api.github.com/users/fubar-coder/events{/privacy}","received_events_url":"https://api.github.com/users/fubar-coder/received_events","type":"User","site_admin":false},"open_issues":19,"closed_issues":35,"state":"open","created_at":"2018-03-28T22:34:27Z","updated_at":"2018-04-13T12:27:52Z","due_on":"2018-04-14T07:00:00Z","closed_at":null},"comments":9,"created_at":"2016-12-27T17:55:50Z","updated_at":"2018-04-13T12:27:52Z","closed_at":"2018-04-13T12:27:52Z","author_association":"NONE","body":"I'm trying to set a default schema extending the VersionTable class, but I figured out there seems to be a bug preventing me to achive that.\r\nWhen the migrator tries to create the UC_VERSION unique index it fails because it's not using the schema defined in SchemaName.\r\n\r\nThis is the error:\r\n[+] CreateIndex VersionInfo (Version)\r\nCREATE UNIQUE INDEX UC_Version ON VersionInfo (Version ASC)    \r\n!!! ORA-00942: table or view does not exist\r\n!!! ORA-00942: table or view does not exist\r\n\r\nSince the creation of the table VersionInfo is using the scheme defined in SchemaName but the creation of the unique is not, it fails.\r\n\r\nHere is my VersionTable class:\r\n\r\n[VersionTableMetaData]\r\n    public class VersionTable : DefaultVersionTableMetaData\r\n    {\r\n        public override string SchemaName\r\n        {\r\n            get { return \"MYSCHEMA\"; }\r\n        }\r\n    }"},"comment":{"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/comments/381119745","html_url":"https://github.com/fluentmigrator/fluentmigrator/issues/764#issuecomment-381119745","issue_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/764","id":381119745,"user":{"login":"fubar-coder","id":4739844,"avatar_url":"https://avatars3.githubusercontent.com/u/4739844?v=4","gravatar_id":"","url":"https://api.github.com/users/fubar-coder","html_url":"https://github.com/fubar-coder","followers_url":"https://api.github.com/users/fubar-coder/followers","following_url":"https://api.github.com/users/fubar-coder/following{/other_user}","gists_url":"https://api.github.com/users/fubar-coder/gists{/gist_id}","starred_url":"https://api.github.com/users/fubar-coder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fubar-coder/subscriptions","organizations_url":"https://api.github.com/users/fubar-coder/orgs","repos_url":"https://api.github.com/users/fubar-coder/repos","events_url":"https://api.github.com/users/fubar-coder/events{/privacy}","received_events_url":"https://api.github.com/users/fubar-coder/received_events","type":"User","site_admin":false},"created_at":"2018-04-13T12:27:52Z","updated_at":"2018-04-13T12:27:52Z","author_association":"OWNER","body":"The schema handling of ORACLE (and other databses) was streamlined and this problem should be fixed in 2.0.0. Please leave a comment if the issue is still there after the 2.0 release."}}
{"actor":{"display_login":"fubar-coder"}}