{"action":"closed","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3452","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3452/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3452/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3452/events","html_url":"https://github.com/orientechnologies/orientdb/issues/3452","id":55316845,"number":3452,"title":"selecting content from an EMBEDDEDLIST of abstract document types fails","user":{"login":"daniellawry","id":1182137,"avatar_url":"https://avatars.githubusercontent.com/u/1182137?v=3","gravatar_id":"","url":"https://api.github.com/users/daniellawry","html_url":"https://github.com/daniellawry","followers_url":"https://api.github.com/users/daniellawry/followers","following_url":"https://api.github.com/users/daniellawry/following{/other_user}","gists_url":"https://api.github.com/users/daniellawry/gists{/gist_id}","starred_url":"https://api.github.com/users/daniellawry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daniellawry/subscriptions","organizations_url":"https://api.github.com/users/daniellawry/orgs","repos_url":"https://api.github.com/users/daniellawry/repos","events_url":"https://api.github.com/users/daniellawry/events{/privacy}","received_events_url":"https://api.github.com/users/daniellawry/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-01-23T18:44:57Z","updated_at":"2015-01-28T13:20:00Z","closed_at":"2015-01-28T13:20:00Z","body":"Version: OrientDB 2.0 (using Studio)\r\n\r\nSteps to Reproduce: \r\n(1) create an abstract document class called \"AbstractDocument\"\r\n(2) create a concrete document class that extends the abstract document class called \"ConcreteDocument\"\r\n(3) create a concrete vertex class (extends V) called \"ConcreteVertex\"\r\n(4) add a single EMBEDDEDLIST property called \"Properties\" to \"ConcreteVertex\" with the list class type set to \"AbstractDocument\"\r\n(4) insert a new instance of \"ConcreteVertex\" with the \"Properties\" EMBEDDEDLIST property containing a single \"ConcreteDocument\" instance\r\n(5) try to select the EMBEDDEDLIST content from the inserted document using the query:\r\n\r\nselect properties from [insert @rid here]\r\n\r\nExpected Result: I'd expect to see the content of the \"Properties\" property as a JSON object\r\n\r\nActual Result: The query executes with no exceptions but no results are returned\r\n\r\nMy Exact Example:\r\n\r\nHere's a sample \"Concept\" object I created with an @rid of #14:0\r\n(Concept is a concrete class that extends V)\r\n\r\n{\r\n\t\"@type\" : \"d\",\r\n\t\"@version\" : 0,\r\n\t\"@class\" : \"Vocabulary\",\r\n\t\"vocabularyEntries\" : [{\r\n\t\t\t\"@type\" : \"d\",\r\n\t\t\t\"@version\" : 0,\r\n\t\t\t\"@class\" : \"VocabularyEntry\",\r\n\t\t\t\"default\" : true,\r\n\t\t\t\"label\" : \"English Label\",\r\n\t\t\t\"description\" : \"English Description\",\r\n\t\t\t\"locale\" : {\r\n\t\t\t\t\"@type\" : \"d\",\r\n\t\t\t\t\"@version\" : 0,\r\n\t\t\t\t\"@class\" : \"Locale\",\r\n\t\t\t\t\"language\" : \"en\",\r\n\t\t\t\t\"country\" : \"US\"\r\n\t\t\t}\r\n\t\t}, {\r\n\t\t\t\"@type\" : \"d\",\r\n\t\t\t\"@version\" : 0,\r\n\t\t\t\"@class\" : \"VocabularyEntry\",\r\n\t\t\t\"default\" : false,\r\n\t\t\t\"label\" : \"French Label\",\r\n\t\t\t\"description\" : \"French Description\",\r\n\t\t\t\"locale\" : {\r\n\t\t\t\t\"@type\" : \"d\",\r\n\t\t\t\t\"@version\" : 0,\r\n\t\t\t\t\"@class\" : \"Locale\",\r\n\t\t\t\t\"language\" : \"fr\",\r\n\t\t\t\t\"country\" : \"CA\"\r\n\t\t\t}\r\n\t\t}\r\n\t],\r\n\t\"properties\" : [{\r\n\t\t\t\"@type\" : \"d\",\r\n\t\t\t\"@version\" : 0,\r\n\t\t\t\"@class\" : \"IntegerProperty\",\r\n\t\t\t\"values\" : [1, 2, 3]\r\n\t\t}, {\r\n\t\t\t\"@type\" : \"d\",\r\n\t\t\t\"@version\" : 0,\r\n\t\t\t\"@class\" : \"StringProperty\",\r\n\t\t\t\"values\" : [\"A\", \"B\", \"C\"]\r\n\t\t}\r\n\t]\r\n}\r\n\r\n\"properties\" is an EMBEDDEDLIST of \"Property\"\r\n\"Property\" is an abstract document type\r\n\"IntegerProperty\" and \"StringProperty\" are concrete document types that extend Property\r\n\r\nI'm trying to write a query that will return the \"properties\" portion of this object but nothing seems to work\r\n\r\nNote: I'm using OrientDB 2.0 and using the studio for my queries\r\n\r\nQuery 1: select properties from #14:2\r\nthis executes without error but returns nothing\r\n\r\nQuery 2: select expand(properties) from #14:2\r\nthis also executes without error and returns nothing\r\n\r\nI do have another EMBEDDEDLIST in use with the vocabulary.vocabularyEntries object\r\nWhen I run the query: select vocabulary.vocabularyEntries from #14:2\r\nI do see the following results:\r\n\r\n[\r\n\t{\r\n\t\t\"@type\" : \"d\",\r\n\t\t\"@version\" : 0,\r\n\t\t\"@class\" : \"VocabularyEntry\",\r\n\t\t\"default\" : true,\r\n\t\t\"label\" : \"English Label\",\r\n\t\t\"description\" : \"English Description\",\r\n\t\t\"locale\" : {\r\n\t\t\t\"@type\" : \"d\",\r\n\t\t\t\"@version\" : 0,\r\n\t\t\t\"@class\" : \"Locale\",\r\n\t\t\t\"language\" : \"en\",\r\n\t\t\t\"country\" : \"US\"\r\n\t\t}\r\n\t}, {\r\n\t\t\"@type\" : \"d\",\r\n\t\t\"@version\" : 0,\r\n\t\t\"@class\" : \"VocabularyEntry\",\r\n\t\t\"default\" : false,\r\n\t\t\"label\" : \"French Label\",\r\n\t\t\"description\" : \"French Description\",\r\n\t\t\"locale\" : {\r\n\t\t\t\"@type\" : \"d\",\r\n\t\t\t\"@version\" : 0,\r\n\t\t\t\"@class\" : \"Locale\",\r\n\t\t\t\"language\" : \"fr\",\r\n\t\t\t\"country\" : \"CA\"\r\n\t\t}\r\n\t}\r\n]\r\n\r\nIs my issue that the \"properties\" field is an EMBEDDEDLIST of an abstract document type (even though what it contains are concrete document types)?  If so, is the only workaround to use a concrete document type instead of an abstract one?"}}