{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3134","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3134/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3134/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3134/events","html_url":"https://github.com/orientechnologies/orientdb/issues/3134","id":51020777,"number":3134,"title":"Property '' Not Exists Error when using ALTER PROPERTY","user":{"login":"bfausett","id":10078919,"avatar_url":"https://avatars.githubusercontent.com/u/10078919?v=3","gravatar_id":"","url":"https://api.github.com/users/bfausett","html_url":"https://github.com/bfausett","followers_url":"https://api.github.com/users/bfausett/followers","following_url":"https://api.github.com/users/bfausett/following{/other_user}","gists_url":"https://api.github.com/users/bfausett/gists{/gist_id}","starred_url":"https://api.github.com/users/bfausett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bfausett/subscriptions","organizations_url":"https://api.github.com/users/bfausett/orgs","repos_url":"https://api.github.com/users/bfausett/repos","events_url":"https://api.github.com/users/bfausett/events{/privacy}","received_events_url":"https://api.github.com/users/bfausett/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/invalid","name":"invalid","color":"e6e6e6"},{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/wontfix","name":"wontfix","color":"ffffff"}],"state":"closed","locked":false,"assignee":{"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},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/28","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/28/labels","id":805641,"number":28,"title":"2.0-RC1 (Release Candidate)","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":0,"closed_issues":88,"state":"closed","created_at":"2014-09-28T12:37:38Z","updated_at":"2015-01-14T23:10:45Z","due_on":"2014-12-16T23:00:00Z","closed_at":"2014-12-17T21:56:03Z"},"comments":14,"created_at":"2014-12-04T19:55:54Z","updated_at":"2015-01-15T19:28:48Z","closed_at":"2014-12-09T16:12:01Z","body":"OrientDB Version: 1.7.9\r\n\r\nI have created a Graph database along with several vertices in a specific Class (Books).  Each vertices has 5 properties, one being \"title\", which stores the title of the book. I have created an index on the \"title\" property within the Books class. I am able to see this property that exists by the following means:\r\n\r\n1- Query vertices from the Book class using the Book.title in the where clause.  Vertices are returned based upon the criteria I specify.\r\n\r\n2- class info Books - which lists the properties\r\n\r\nINDEXES (2 altogether)\r\n-------------------------------+----------------+\r\n NAME                          | PROPERTIES     |\r\n-------------------------------+----------------+\r\n Books.fullName              | fullName       |\r\n Books.title                 | title          |\r\n-------------------------------+----------------+\r\n\r\nI realized that I wanted to be able to search for book titles in a case insensitive manner.  I found within the OrientDB documentation the ALTER PROPERTY command.  Each time I try to execute the following command:\r\n\r\nALTER PROPERTY Books.title COLLATE \"ci\"\r\n\r\nI then get the following error:\r\n\r\nError: com.orientechnologies.orient.core.exception.OCommandExecutionException: P\r\nroperty 'Books.title' not exists.\r\n\r\nHow can I get past this error?  Any help would be appreciated.\r\n\r\nThanks,\r\nbfausett\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/70145803","html_url":"https://github.com/orientechnologies/orientdb/issues/3134#issuecomment-70145803","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3134","id":70145803,"user":{"login":"na2014","id":10550534,"avatar_url":"https://avatars.githubusercontent.com/u/10550534?v=3","gravatar_id":"","url":"https://api.github.com/users/na2014","html_url":"https://github.com/na2014","followers_url":"https://api.github.com/users/na2014/followers","following_url":"https://api.github.com/users/na2014/following{/other_user}","gists_url":"https://api.github.com/users/na2014/gists{/gist_id}","starred_url":"https://api.github.com/users/na2014/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/na2014/subscriptions","organizations_url":"https://api.github.com/users/na2014/orgs","repos_url":"https://api.github.com/users/na2014/repos","events_url":"https://api.github.com/users/na2014/events{/privacy}","received_events_url":"https://api.github.com/users/na2014/received_events","type":"User","site_admin":false},"created_at":"2015-01-15T19:28:48Z","updated_at":"2015-01-15T19:28:48Z","body":"My issue was resolved in the other post, though the process was rather confusing.  Take a look and see if it helps at all.\r\n\r\n"}}