{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/9195","repository_url":"https://api.github.com/repos/cakephp/cakephp","labels_url":"https://api.github.com/repos/cakephp/cakephp/issues/9195/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/cakephp/issues/9195/comments","events_url":"https://api.github.com/repos/cakephp/cakephp/issues/9195/events","html_url":"https://github.com/cakephp/cakephp/issues/9195","id":168543643,"number":9195,"title":"Query::update() does not support LIMIT","user":{"login":"thinkingmedia","id":551022,"avatar_url":"https://avatars.githubusercontent.com/u/551022?v=3","gravatar_id":"","url":"https://api.github.com/users/thinkingmedia","html_url":"https://github.com/thinkingmedia","followers_url":"https://api.github.com/users/thinkingmedia/followers","following_url":"https://api.github.com/users/thinkingmedia/following{/other_user}","gists_url":"https://api.github.com/users/thinkingmedia/gists{/gist_id}","starred_url":"https://api.github.com/users/thinkingmedia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thinkingmedia/subscriptions","organizations_url":"https://api.github.com/users/thinkingmedia/orgs","repos_url":"https://api.github.com/users/thinkingmedia/repos","events_url":"https://api.github.com/users/thinkingmedia/events{/privacy}","received_events_url":"https://api.github.com/users/thinkingmedia/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cakephp/cakephp/labels/ORM","name":"ORM","color":"ffffff"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/cakephp/cakephp/milestones/94","html_url":"https://github.com/cakephp/cakephp/milestones/3.2.13","labels_url":"https://api.github.com/repos/cakephp/cakephp/milestones/94/labels","id":1873308,"number":94,"title":"3.2.13","description":"Bugfixes and minor new features","creator":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"open_issues":33,"closed_issues":69,"state":"open","created_at":"2016-07-09T02:15:15Z","updated_at":"2016-08-01T02:24:04Z","due_on":"2016-07-31T04:00:00Z","closed_at":null},"comments":7,"created_at":"2016-07-31T23:14:45Z","updated_at":"2016-08-01T14:07:55Z","closed_at":null,"body":"This is a (multiple allowed):\r\n* [x] bug\r\n* [ ] enhancement\r\n* [ ] feature-discussion (RFC)\r\n\r\n* CakePHP Version: 3.2.12\r\n* Platform and Target: Apache2, MySQL, PHP 7\r\n\r\n### What you did\r\n\r\nTrying to create a custom update query that has a LIMIT 1\r\n\r\n```\r\n    $query = $documents->query()->update()->set(['title'=>'foo'])->limit(1);\r\n    Log::info((string)$query);\r\n```\r\n\r\nOutput:\r\n\r\n```\r\n   UPDATE `documents` SET `title` = :c0\r\n```\r\n\r\n### Expected Behavior\r\n\r\nMySQL supports LIMIT on UPDATE queries, but the ORM is not adding the LIMIT clause.\r\n\r\n### Actual Behavior\r\n\r\nAll records are updated. :cry: "},"comment":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/comments/236590520","html_url":"https://github.com/cakephp/cakephp/issues/9195#issuecomment-236590520","issue_url":"https://api.github.com/repos/cakephp/cakephp/issues/9195","id":236590520,"user":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"created_at":"2016-08-01T14:07:55Z","updated_at":"2016-08-01T14:07:55Z","body":"@thinkingmedia The underlying database will throw an exception when it encounters sql it can't run. Won't that be enough?"}}
{"actor":{"display_login":"markstory"}}