{"action":"created","issue":{"url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/issues/2","repository_url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility","labels_url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/issues/2/comments","events_url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/issues/2/events","html_url":"https://github.com/LifeOrYou/cakephp-firebird-utility/issues/2","id":257902576,"number":2,"title":"Implementation limit exceeded Too many values (more than 1500)","user":{"login":"riicardofarias","id":4837465,"avatar_url":"https://avatars3.githubusercontent.com/u/4837465?v=4","gravatar_id":"","url":"https://api.github.com/users/riicardofarias","html_url":"https://github.com/riicardofarias","followers_url":"https://api.github.com/users/riicardofarias/followers","following_url":"https://api.github.com/users/riicardofarias/following{/other_user}","gists_url":"https://api.github.com/users/riicardofarias/gists{/gist_id}","starred_url":"https://api.github.com/users/riicardofarias/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/riicardofarias/subscriptions","organizations_url":"https://api.github.com/users/riicardofarias/orgs","repos_url":"https://api.github.com/users/riicardofarias/repos","events_url":"https://api.github.com/users/riicardofarias/events{/privacy}","received_events_url":"https://api.github.com/users/riicardofarias/received_events","type":"User","site_admin":false},"labels":[{"id":454901610,"url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"LifeOrYou","id":17439824,"avatar_url":"https://avatars0.githubusercontent.com/u/17439824?v=4","gravatar_id":"","url":"https://api.github.com/users/LifeOrYou","html_url":"https://github.com/LifeOrYou","followers_url":"https://api.github.com/users/LifeOrYou/followers","following_url":"https://api.github.com/users/LifeOrYou/following{/other_user}","gists_url":"https://api.github.com/users/LifeOrYou/gists{/gist_id}","starred_url":"https://api.github.com/users/LifeOrYou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LifeOrYou/subscriptions","organizations_url":"https://api.github.com/users/LifeOrYou/orgs","repos_url":"https://api.github.com/users/LifeOrYou/repos","events_url":"https://api.github.com/users/LifeOrYou/events{/privacy}","received_events_url":"https://api.github.com/users/LifeOrYou/received_events","type":"User","site_admin":false},"assignees":[{"login":"LifeOrYou","id":17439824,"avatar_url":"https://avatars0.githubusercontent.com/u/17439824?v=4","gravatar_id":"","url":"https://api.github.com/users/LifeOrYou","html_url":"https://github.com/LifeOrYou","followers_url":"https://api.github.com/users/LifeOrYou/followers","following_url":"https://api.github.com/users/LifeOrYou/following{/other_user}","gists_url":"https://api.github.com/users/LifeOrYou/gists{/gist_id}","starred_url":"https://api.github.com/users/LifeOrYou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LifeOrYou/subscriptions","organizations_url":"https://api.github.com/users/LifeOrYou/orgs","repos_url":"https://api.github.com/users/LifeOrYou/repos","events_url":"https://api.github.com/users/LifeOrYou/events{/privacy}","received_events_url":"https://api.github.com/users/LifeOrYou/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2017-09-15T01:37:36Z","updated_at":"2017-09-16T15:16:43Z","closed_at":null,"author_association":"NONE","body":"Hello,\r\n\r\nWhen i use the hasMany association I will receive this error when the results exceed 1500 records.\r\n\r\n`SQLSTATE[HY000]: General error: -901 Dynamic SQL Error SQL error code = -901 Implementation limit exceeded Too many values (more than 1500) in member list to match against`\r\n\r\nBecause the query contains `WHERE Pesagens.ANIMAL_ID in (:c0,:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10...`. I replaced \"IN\" to \"SIMILAR TO\" on SGDB and works fine, but i dont' know how do this in CakePHP."},"comment":{"url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/issues/comments/329974609","html_url":"https://github.com/LifeOrYou/cakephp-firebird-utility/issues/2#issuecomment-329974609","issue_url":"https://api.github.com/repos/LifeOrYou/cakephp-firebird-utility/issues/2","id":329974609,"user":{"login":"LifeOrYou","id":17439824,"avatar_url":"https://avatars0.githubusercontent.com/u/17439824?v=4","gravatar_id":"","url":"https://api.github.com/users/LifeOrYou","html_url":"https://github.com/LifeOrYou","followers_url":"https://api.github.com/users/LifeOrYou/followers","following_url":"https://api.github.com/users/LifeOrYou/following{/other_user}","gists_url":"https://api.github.com/users/LifeOrYou/gists{/gist_id}","starred_url":"https://api.github.com/users/LifeOrYou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LifeOrYou/subscriptions","organizations_url":"https://api.github.com/users/LifeOrYou/orgs","repos_url":"https://api.github.com/users/LifeOrYou/repos","events_url":"https://api.github.com/users/LifeOrYou/events{/privacy}","received_events_url":"https://api.github.com/users/LifeOrYou/received_events","type":"User","site_admin":false},"created_at":"2017-09-16T15:16:43Z","updated_at":"2017-09-16T15:16:43Z","author_association":"OWNER","body":"Hum, i know this limitation of firebird but i can't do anything on this because the were sql part is build in CakePhp core file. I can't override the comportement in this driver.\r\n\r\nIf you need a alternative, i should you insert result of this query in temporary table and on another query you can join on this temporary table."}}
{"actor":{"display_login":"LifeOrYou"}}