{"action":"created","issue":{"url":"https://api.github.com/repos/UnionOfRAD/lithium/issues/1163","labels_url":"https://api.github.com/repos/UnionOfRAD/lithium/issues/1163/labels{/name}","comments_url":"https://api.github.com/repos/UnionOfRAD/lithium/issues/1163/comments","events_url":"https://api.github.com/repos/UnionOfRAD/lithium/issues/1163/events","html_url":"https://github.com/UnionOfRAD/lithium/issues/1163","id":56993742,"number":1163,"title":"saving data (though not updated entries) with whitelist renders wrong sql","user":{"login":"jovanialferez","id":1515234,"avatar_url":"https://avatars.githubusercontent.com/u/1515234?v=3","gravatar_id":"","url":"https://api.github.com/users/jovanialferez","html_url":"https://github.com/jovanialferez","followers_url":"https://api.github.com/users/jovanialferez/followers","following_url":"https://api.github.com/users/jovanialferez/following{/other_user}","gists_url":"https://api.github.com/users/jovanialferez/gists{/gist_id}","starred_url":"https://api.github.com/users/jovanialferez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jovanialferez/subscriptions","organizations_url":"https://api.github.com/users/jovanialferez/orgs","repos_url":"https://api.github.com/users/jovanialferez/repos","events_url":"https://api.github.com/users/jovanialferez/events{/privacy}","received_events_url":"https://api.github.com/users/jovanialferez/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/UnionOfRAD/lithium/labels/bug","name":"bug","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/UnionOfRAD/lithium/milestones/4","html_url":"https://github.com/UnionOfRAD/lithium/milestones/1.0","labels_url":"https://api.github.com/repos/UnionOfRAD/lithium/milestones/4/labels","id":531747,"number":4,"title":"1.0","description":"This is it.","creator":{"login":"nateabele","id":18288,"avatar_url":"https://avatars.githubusercontent.com/u/18288?v=3","gravatar_id":"","url":"https://api.github.com/users/nateabele","html_url":"https://github.com/nateabele","followers_url":"https://api.github.com/users/nateabele/followers","following_url":"https://api.github.com/users/nateabele/following{/other_user}","gists_url":"https://api.github.com/users/nateabele/gists{/gist_id}","starred_url":"https://api.github.com/users/nateabele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nateabele/subscriptions","organizations_url":"https://api.github.com/users/nateabele/orgs","repos_url":"https://api.github.com/users/nateabele/repos","events_url":"https://api.github.com/users/nateabele/events{/privacy}","received_events_url":"https://api.github.com/users/nateabele/received_events","type":"User","site_admin":false},"open_issues":8,"closed_issues":27,"state":"open","created_at":"2014-01-09T20:33:37Z","updated_at":"2015-03-14T17:25:22Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2015-02-09T06:28:23Z","updated_at":"2015-03-17T15:51:06Z","closed_at":null,"body":"i had this snippet which was working as of 6eecce29:\r\n\r\n$model->fieldOne = 'same_value_as_before';\r\n$model->save(null, ['whitellist' => ['fieldOne']]);\r\n\r\nIf there were no actual update, such that fieldOne is still assigned to same value, save() causes to render an sql with no field SET e.g. `update my_table SET WHERE id=123`.\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/UnionOfRAD/lithium/issues/comments/82429735","html_url":"https://github.com/UnionOfRAD/lithium/issues/1163#issuecomment-82429735","issue_url":"https://api.github.com/repos/UnionOfRAD/lithium/issues/1163","id":82429735,"user":{"login":"davidpersson","id":29702,"avatar_url":"https://avatars.githubusercontent.com/u/29702?v=3","gravatar_id":"","url":"https://api.github.com/users/davidpersson","html_url":"https://github.com/davidpersson","followers_url":"https://api.github.com/users/davidpersson/followers","following_url":"https://api.github.com/users/davidpersson/following{/other_user}","gists_url":"https://api.github.com/users/davidpersson/gists{/gist_id}","starred_url":"https://api.github.com/users/davidpersson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidpersson/subscriptions","organizations_url":"https://api.github.com/users/davidpersson/orgs","repos_url":"https://api.github.com/users/davidpersson/repos","events_url":"https://api.github.com/users/davidpersson/events{/privacy}","received_events_url":"https://api.github.com/users/davidpersson/received_events","type":"User","site_admin":false},"created_at":"2015-03-17T15:51:06Z","updated_at":"2015-03-17T15:51:06Z","body":"I have reverted the original commit that added the incremental update feature to the `dev` branch as - after some investigation - I didn't find a fix by myself for this. This feature probably needs a little bit more work (see @farhadi's comment) and we're fine.  \r\n\r\nHowever I really would like to see this feature in 1.0.\r\n\r\nTherefore I've created a feature branch under `feature/incremental-db-update`. That contains the original patch and test cases by @koushki as well as some tests added by me.\r\n\r\n@koushki if your or anybody else would like to pick up the work here, take the commits from that branch and submit a new PR, I'd be glad to help. \r\n\r\n"}}