{"action":"created","issue":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/11363","repository_url":"https://api.github.com/repos/yiisoft/yii2","labels_url":"https://api.github.com/repos/yiisoft/yii2/issues/11363/labels{/name}","comments_url":"https://api.github.com/repos/yiisoft/yii2/issues/11363/comments","events_url":"https://api.github.com/repos/yiisoft/yii2/issues/11363/events","html_url":"https://github.com/yiisoft/yii2/pull/11363","id":148829871,"number":11363,"title":"#9425: ActiveQuery::exists() should generate SELECT EXISTS()","user":{"login":"PowerGamer1","id":8275897,"avatar_url":"https://avatars.githubusercontent.com/u/8275897?v=3","gravatar_id":"","url":"https://api.github.com/users/PowerGamer1","html_url":"https://github.com/PowerGamer1","followers_url":"https://api.github.com/users/PowerGamer1/followers","following_url":"https://api.github.com/users/PowerGamer1/following{/other_user}","gists_url":"https://api.github.com/users/PowerGamer1/gists{/gist_id}","starred_url":"https://api.github.com/users/PowerGamer1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PowerGamer1/subscriptions","organizations_url":"https://api.github.com/users/PowerGamer1/orgs","repos_url":"https://api.github.com/users/PowerGamer1/repos","events_url":"https://api.github.com/users/PowerGamer1/events{/privacy}","received_events_url":"https://api.github.com/users/PowerGamer1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/yiisoft/yii2/labels/feature:db","name":"feature:db","color":"bfd4f2"},{"url":"https://api.github.com/repos/yiisoft/yii2/labels/type:enhancement","name":"type:enhancement","color":"d7e102"}],"state":"closed","locked":false,"assignee":{"login":"samdark","id":47294,"avatar_url":"https://avatars.githubusercontent.com/u/47294?v=3","gravatar_id":"","url":"https://api.github.com/users/samdark","html_url":"https://github.com/samdark","followers_url":"https://api.github.com/users/samdark/followers","following_url":"https://api.github.com/users/samdark/following{/other_user}","gists_url":"https://api.github.com/users/samdark/gists{/gist_id}","starred_url":"https://api.github.com/users/samdark/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/samdark/subscriptions","organizations_url":"https://api.github.com/users/samdark/orgs","repos_url":"https://api.github.com/users/samdark/repos","events_url":"https://api.github.com/users/samdark/events{/privacy}","received_events_url":"https://api.github.com/users/samdark/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/yiisoft/yii2/milestones/16","html_url":"https://github.com/yiisoft/yii2/milestones/2.0.8","labels_url":"https://api.github.com/repos/yiisoft/yii2/milestones/16/labels","id":1242959,"number":16,"title":"2.0.8","description":"","creator":{"login":"cebe","id":189796,"avatar_url":"https://avatars.githubusercontent.com/u/189796?v=3","gravatar_id":"","url":"https://api.github.com/users/cebe","html_url":"https://github.com/cebe","followers_url":"https://api.github.com/users/cebe/followers","following_url":"https://api.github.com/users/cebe/following{/other_user}","gists_url":"https://api.github.com/users/cebe/gists{/gist_id}","starred_url":"https://api.github.com/users/cebe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cebe/subscriptions","organizations_url":"https://api.github.com/users/cebe/orgs","repos_url":"https://api.github.com/users/cebe/repos","events_url":"https://api.github.com/users/cebe/events{/privacy}","received_events_url":"https://api.github.com/users/cebe/received_events","type":"User","site_admin":false},"open_issues":56,"closed_issues":194,"state":"open","created_at":"2015-08-05T22:18:21Z","updated_at":"2016-04-16T14:56:47Z","due_on":"2016-04-23T21:00:00Z","closed_at":null},"comments":8,"created_at":"2016-04-16T08:11:42Z","updated_at":"2016-04-16T16:26:40Z","closed_at":"2016-04-16T10:34:20Z","pull_request":{"url":"https://api.github.com/repos/yiisoft/yii2/pulls/11363","html_url":"https://github.com/yiisoft/yii2/pull/11363","diff_url":"https://github.com/yiisoft/yii2/pull/11363.diff","patch_url":"https://github.com/yiisoft/yii2/pull/11363.patch"},"body":"| Q             | A\r\n| ------------- | ---\r\n| Is bugfix?    | no\r\n| New feature?  | no\r\n| Breaks BC?    | no\r\n| Tests pass?   | yes\r\n| Fixed issues  | 9425\r\n\r\nImplementation of https://github.com/yiisoft/yii2/issues/9425."},"comment":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/comments/210849672","html_url":"https://github.com/yiisoft/yii2/pull/11363#issuecomment-210849672","issue_url":"https://api.github.com/repos/yiisoft/yii2/issues/11363","id":210849672,"user":{"login":"PowerGamer1","id":8275897,"avatar_url":"https://avatars.githubusercontent.com/u/8275897?v=3","gravatar_id":"","url":"https://api.github.com/users/PowerGamer1","html_url":"https://github.com/PowerGamer1","followers_url":"https://api.github.com/users/PowerGamer1/followers","following_url":"https://api.github.com/users/PowerGamer1/following{/other_user}","gists_url":"https://api.github.com/users/PowerGamer1/gists{/gist_id}","starred_url":"https://api.github.com/users/PowerGamer1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PowerGamer1/subscriptions","organizations_url":"https://api.github.com/users/PowerGamer1/orgs","repos_url":"https://api.github.com/users/PowerGamer1/repos","events_url":"https://api.github.com/users/PowerGamer1/events{/privacy}","received_events_url":"https://api.github.com/users/PowerGamer1/received_events","type":"User","site_admin":false},"created_at":"2016-04-16T16:26:40Z","updated_at":"2016-04-16T16:26:40Z","body":"@klimov-paul \r\n> That is not true: there is NO unit test, which actually runs `Query::exists()` method.\r\n\r\n`Query::exists()` runs as part of `UniqueValidator` unit tests.\r\n\r\nAlso, apparently Cubrid, MSSQL and Oracle do not support SQL92 standard form of `SELECT EXISTS()` but they do support their own nearly identical forms of it. Implemented them in https://github.com/yiisoft/yii2/issues/11369."}}