{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6648","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6648/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6648/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6648/events","html_url":"https://github.com/orientechnologies/orientdb/issues/6648","id":174711656,"number":6648,"title":"deleting property's attribute \"regexp\"  does not work","user":{"login":"Ivanov-Yuriy","id":7984378,"avatar_url":"https://avatars.githubusercontent.com/u/7984378?v=3","gravatar_id":"","url":"https://api.github.com/users/Ivanov-Yuriy","html_url":"https://github.com/Ivanov-Yuriy","followers_url":"https://api.github.com/users/Ivanov-Yuriy/followers","following_url":"https://api.github.com/users/Ivanov-Yuriy/following{/other_user}","gists_url":"https://api.github.com/users/Ivanov-Yuriy/gists{/gist_id}","starred_url":"https://api.github.com/users/Ivanov-Yuriy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ivanov-Yuriy/subscriptions","organizations_url":"https://api.github.com/users/Ivanov-Yuriy/orgs","repos_url":"https://api.github.com/users/Ivanov-Yuriy/repos","events_url":"https://api.github.com/users/Ivanov-Yuriy/events{/privacy}","received_events_url":"https://api.github.com/users/Ivanov-Yuriy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-02T08:55:29Z","updated_at":"2016-09-02T09:19:43Z","closed_at":null,"body":"## OrientDB Version, operating system, or hardware.\r\n- v2.2.8\r\n\r\n## Operating System\r\n- [ ] Linux\r\n- [ ] MacOSX\r\n- [x] Windows\r\n- [ ] Other Unix\r\n- [ ] Other, name? \r\n\r\n## Expected behavior and actual behavior\r\nattribute should be deleted when I use command:\r\n**alter property test.prop regexp null**\r\n\r\n## Steps to reproduce the problem\r\n\r\norientdb {db=test}> **create class test extends V**\r\nClass created successfully. Total classes in database now: 12.\r\n\r\norientdb {db=test}> **create property test.prop string**\r\nProperty created successfully with id=1.\r\n\r\norientdb {db=test}> **alter property test.prop regexp '[a-z]'**\r\nProperty updated successfully.\r\n\r\norientdb {db=test}> **select expand(properties)  from ( select expand(classes) from metadata:schema) where name = 'test'**\r\n\r\n+----+----+----+--------+---------+--------+-------+------------+----+----+------------+-------+-----------+------+\r\n|#   |name|type|globalId|mandatory|readonly|notNull|defaultValue|min |max |customFields|collate|description|regexp|\r\n+----+----+----+--------+---------+--------+-------+------------+----+----+------------+-------+-----------+------+\r\n|0   |prop|7   |23      |false    |false   |false  |            |    |    |            |default|           **|[a-z]** |\r\n+----+----+----+--------+---------+--------+-------+------------+----+----+------------+-------+-----------+------+\r\n1 item(s) found. Query executed in 0.004 sec(s).\r\n\r\norientdb {db=test}> **alter property test.prop regexp null**\r\nProperty updated successfully.\r\n\r\norientdb {db=test}> **select expand(properties)  from ( select expand(classes) from metadata:schema) where name = 'test'**\r\n+----+----+----+--------+---------+--------+-------+------------+----+----+------------+-------+-----------+------+\r\n|#   |name|type|globalId|mandatory|readonly|notNull|defaultValue|min |max |customFields|collate|description|regexp|\r\n+----+----+----+--------+---------+--------+-------+------------+----+----+------------+-------+-----------+------+\r\n|0   |prop|7   |23      |false    |false   |false  |            |    |    |            |default|           |**[a-z]** |\r\n+----+----+----+--------+---------+--------+-------+------------+----+----+------------+-------+-----------+------+\r\n1 item(s) found. Query executed in 0.003 sec(s)."},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/244325979","html_url":"https://github.com/orientechnologies/orientdb/issues/6648#issuecomment-244325979","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6648","id":244325979,"user":{"login":"smolinari","id":3314957,"avatar_url":"https://avatars.githubusercontent.com/u/3314957?v=3","gravatar_id":"","url":"https://api.github.com/users/smolinari","html_url":"https://github.com/smolinari","followers_url":"https://api.github.com/users/smolinari/followers","following_url":"https://api.github.com/users/smolinari/following{/other_user}","gists_url":"https://api.github.com/users/smolinari/gists{/gist_id}","starred_url":"https://api.github.com/users/smolinari/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smolinari/subscriptions","organizations_url":"https://api.github.com/users/smolinari/orgs","repos_url":"https://api.github.com/users/smolinari/repos","events_url":"https://api.github.com/users/smolinari/events{/privacy}","received_events_url":"https://api.github.com/users/smolinari/received_events","type":"User","site_admin":false},"created_at":"2016-09-02T09:19:43Z","updated_at":"2016-09-02T09:19:43Z","body":"Could it be, that it should only be \"regex\" and not \"regexp\"?\r\n\r\n@luigidellaquila - the documentation is ambiguous, because the examples have \"REGEXP\", but the table with the supported attributes has \"REGEX\".\r\n\r\nScott"}}
{"actor":{"display_login":"smolinari"}}