{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5136","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5136/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5136/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5136/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5136","id":111847832,"number":5136,"title":"possible enhancements for next releases ","user":{"login":"publicocean0","id":2518180,"avatar_url":"https://avatars.githubusercontent.com/u/2518180?v=3","gravatar_id":"","url":"https://api.github.com/users/publicocean0","html_url":"https://github.com/publicocean0","followers_url":"https://api.github.com/users/publicocean0/followers","following_url":"https://api.github.com/users/publicocean0/following{/other_user}","gists_url":"https://api.github.com/users/publicocean0/gists{/gist_id}","starred_url":"https://api.github.com/users/publicocean0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/publicocean0/subscriptions","organizations_url":"https://api.github.com/users/publicocean0/orgs","repos_url":"https://api.github.com/users/publicocean0/repos","events_url":"https://api.github.com/users/publicocean0/events{/privacy}","received_events_url":"https://api.github.com/users/publicocean0/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"assignees":[{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.1.x%20(next%20hotfix)","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64/labels","id":1282180,"number":64,"title":"2.1.x (next hotfix)","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":92,"closed_issues":0,"state":"open","created_at":"2015-08-31T15:18:49Z","updated_at":"2016-08-23T07:49:17Z","due_on":null,"closed_at":null},"comments":17,"created_at":"2015-10-16T14:51:58Z","updated_at":"2016-08-23T22:08:24Z","closed_at":null,"body":"<B>Partial match search enhancement</B>\r\nReference : http://orientdb.com/docs/2.1/Indexes.html\r\n\r\ncomposite keys is a+b \r\nnow it is possible to do :\r\n<pre>\r\n SELECT FROM INDEX:books WHERE key = ['key1','key2']\r\nSELECT FROM INDEX:books WHERE key = 'key1'\r\n</pre>\r\nit advice to add ( if it is possible , i didnt see the implementation)\r\n<pre>\r\nSELECT FROM INDEX:books WHERE key.a = 'key1' \r\nSELECT FROM INDEX:books WHERE key.b = 'key2'\r\n</pre>\r\nThis evoid to add a second index it you want search for b and not for a.... :) \r\n\r\n <B>DELETE ON CASCADE</B>\r\n<pre>\r\ndelete from #10:21  cascade ['p1','p2']\r\n</pre>\r\nit permits to remove the node and the subnodes in properties p1 and p2\r\n\r\n <B>COPY</B>\r\n<pre>\r\ncopy from #10:21 to <class>  cascade ['p1','p2']\r\n</pre> \r\n it permits to copy the node createning a new one makiing the same recursively for sub nodes for property p1 and p2, for the remaining is copying just the link\r\n\r\n<B>ON FETCH </B>\r\n<pre>\r\nselect .... on fetch ( delete|insert|..... commands)\r\n</pre>\r\nit permits to execute a nested command (removal , updating , insertion...) for every row found in the select. it permits to add a feature executing massive commands using few server resources on huge results . It adds indirectly powerfull also to batch script (just way to use use transaction with sql commands ) because you can filter modifications in a transaction permitting to change the effects based on server results and not only based non client parameters. \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/241896237","html_url":"https://github.com/orientechnologies/orientdb/issues/5136#issuecomment-241896237","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5136","id":241896237,"user":{"login":"publicocean0","id":2518180,"avatar_url":"https://avatars.githubusercontent.com/u/2518180?v=3","gravatar_id":"","url":"https://api.github.com/users/publicocean0","html_url":"https://github.com/publicocean0","followers_url":"https://api.github.com/users/publicocean0/followers","following_url":"https://api.github.com/users/publicocean0/following{/other_user}","gists_url":"https://api.github.com/users/publicocean0/gists{/gist_id}","starred_url":"https://api.github.com/users/publicocean0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/publicocean0/subscriptions","organizations_url":"https://api.github.com/users/publicocean0/orgs","repos_url":"https://api.github.com/users/publicocean0/repos","events_url":"https://api.github.com/users/publicocean0/events{/privacy}","received_events_url":"https://api.github.com/users/publicocean0/received_events","type":"User","site_admin":false},"created_at":"2016-08-23T22:08:24Z","updated_at":"2016-08-23T22:08:24Z","body":"There is a good book explaining very well topics above.\r\n\"Costruire sistemi di basi di dati\" di antonio albano. Addison wesley. You can find algorithms for sorting and searching for attributes with variable length"}}
{"actor":{"display_login":"publicocean0"}}