{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/18976","labels_url":"https://api.github.com/repos/owncloud/core/issues/18976/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/18976/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/18976/events","html_url":"https://github.com/owncloud/core/pull/18976","id":105992088,"number":18976,"title":"Cast clobs to strings for comparison on Oracle","user":{"login":"Xenopathic","id":2016878,"avatar_url":"https://avatars.githubusercontent.com/u/2016878?v=3","gravatar_id":"","url":"https://api.github.com/users/Xenopathic","html_url":"https://github.com/Xenopathic","followers_url":"https://api.github.com/users/Xenopathic/followers","following_url":"https://api.github.com/users/Xenopathic/following{/other_user}","gists_url":"https://api.github.com/users/Xenopathic/gists{/gist_id}","starred_url":"https://api.github.com/users/Xenopathic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Xenopathic/subscriptions","organizations_url":"https://api.github.com/users/Xenopathic/orgs","repos_url":"https://api.github.com/users/Xenopathic/repos","events_url":"https://api.github.com/users/Xenopathic/events{/privacy}","received_events_url":"https://api.github.com/users/Xenopathic/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/2%20-%20Developing","name":"2 - Developing","color":"ededed"},{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:oracle","name":"db:oracle","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/regression","name":"regression","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/37","html_url":"https://github.com/owncloud/core/milestones/8.2-current","labels_url":"https://api.github.com/repos/owncloud/core/milestones/37/labels","id":993629,"number":37,"title":"8.2-current","description":"","creator":{"login":"craigpg","id":160667,"avatar_url":"https://avatars.githubusercontent.com/u/160667?v=3","gravatar_id":"","url":"https://api.github.com/users/craigpg","html_url":"https://github.com/craigpg","followers_url":"https://api.github.com/users/craigpg/followers","following_url":"https://api.github.com/users/craigpg/following{/other_user}","gists_url":"https://api.github.com/users/craigpg/gists{/gist_id}","starred_url":"https://api.github.com/users/craigpg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigpg/subscriptions","organizations_url":"https://api.github.com/users/craigpg/orgs","repos_url":"https://api.github.com/users/craigpg/repos","events_url":"https://api.github.com/users/craigpg/events{/privacy}","received_events_url":"https://api.github.com/users/craigpg/received_events","type":"User","site_admin":false},"open_issues":613,"closed_issues":684,"state":"open","created_at":"2015-02-24T16:19:37Z","updated_at":"2015-09-14T06:07:20Z","due_on":"2015-10-20T04:00:00Z","closed_at":null},"comments":5,"created_at":"2015-09-11T11:28:46Z","updated_at":"2015-09-14T06:50:22Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/owncloud/core/pulls/18976","html_url":"https://github.com/owncloud/core/pull/18976","diff_url":"https://github.com/owncloud/core/pull/18976.diff","patch_url":"https://github.com/owncloud/core/pull/18976.patch"},"body":"Clob values need to be casted using `to_char()` for comparisons on Oracle. This was already being used in AllConfig for the precondition stuff, I've generalized it and integrated it with the QueryBuilder so it's easier to use. Needs testing on Oracle of course.\r\n\r\nI'll get some unit tests working for this soon.\r\n\r\ncc @nickvergessen @butonic @DeepDiver1975 \r\n\r\nFixes #18949 "},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/139978293","html_url":"https://github.com/owncloud/core/pull/18976#issuecomment-139978293","issue_url":"https://api.github.com/repos/owncloud/core/issues/18976","id":139978293,"user":{"login":"scrutinizer-notifier","id":6398257,"avatar_url":"https://avatars.githubusercontent.com/u/6398257?v=3","gravatar_id":"","url":"https://api.github.com/users/scrutinizer-notifier","html_url":"https://github.com/scrutinizer-notifier","followers_url":"https://api.github.com/users/scrutinizer-notifier/followers","following_url":"https://api.github.com/users/scrutinizer-notifier/following{/other_user}","gists_url":"https://api.github.com/users/scrutinizer-notifier/gists{/gist_id}","starred_url":"https://api.github.com/users/scrutinizer-notifier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scrutinizer-notifier/subscriptions","organizations_url":"https://api.github.com/users/scrutinizer-notifier/orgs","repos_url":"https://api.github.com/users/scrutinizer-notifier/repos","events_url":"https://api.github.com/users/scrutinizer-notifier/events{/privacy}","received_events_url":"https://api.github.com/users/scrutinizer-notifier/received_events","type":"User","site_admin":false},"created_at":"2015-09-14T06:50:22Z","updated_at":"2015-09-14T06:50:22Z","body":"A [new inspection](https://scrutinizer-ci.com/g/owncloud/core/inspections/223b5d04-449b-4c6b-a54c-496c847fb777) was created."}}