{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5474","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5474/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5474/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5474/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5474","id":122439475,"number":5474,"title":"Error when using EMBEDDED LINKEDCLASS data type with INSERT, UPDATE Content","user":{"login":"healiseu","id":14239698,"avatar_url":"https://avatars.githubusercontent.com/u/14239698?v=3","gravatar_id":"","url":"https://api.github.com/users/healiseu","html_url":"https://github.com/healiseu","followers_url":"https://api.github.com/users/healiseu/followers","following_url":"https://api.github.com/users/healiseu/following{/other_user}","gists_url":"https://api.github.com/users/healiseu/gists{/gist_id}","starred_url":"https://api.github.com/users/healiseu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/healiseu/subscriptions","organizations_url":"https://api.github.com/users/healiseu/orgs","repos_url":"https://api.github.com/users/healiseu/repos","events_url":"https://api.github.com/users/healiseu/events{/privacy}","received_events_url":"https://api.github.com/users/healiseu/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},"milestone":null,"comments":7,"created_at":"2015-12-16T06:30:15Z","updated_at":"2015-12-16T13:34:42Z","closed_at":null,"body":"Hi, I am using OrientDB community edition 2.1.6 and I have a problem using **EMBEDDED**, **EMBEDDEDSET**, etc data types and the INSERT CONTENT, UPDATE CONTENT sql commands when you add the attribute **LINKEDCLASS** on the embedded type property. Try the following code to reproduce it.\r\n\r\n```sql\r\ncreate class Person\r\ncreate property Person.nameFirst STRING\r\ncreate property Person.nameLast STRING\r\n\r\ncreate class Film\r\ncreate property Film.title STRING\r\ncreate property Film.actor EMBEDDED Person\r\n\r\ninsert into Film set title=\"Catch me if you can\", actor={\"nameFirst\":\"Leonardo\",\"nameLast\":\"DiCaprio\"}\r\n\r\ninsert into Film CONTENT {\"actor\":{\"nameFirst\":\"Leonardo\",\"nameLast\":\"DiCaprio\"}}\r\n```\r\n\r\nThe error occurs when the `INSERT into Film CONTENT` command is executed and the message is\r\n\r\n`The field 'Film.actor' has been declared as EMBEDDED but an incompatible type is used. Value: {nameFirst=Leonardo, nameLast=DiCaprio}`\r\n\r\nI believe my syntax for this INSERT command is correct, if not please help"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/165107435","html_url":"https://github.com/orientechnologies/orientdb/issues/5474#issuecomment-165107435","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5474","id":165107435,"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":"2015-12-16T13:34:42Z","updated_at":"2015-12-16T13:34:42Z","body":"All this could be a good section for the \"Insert\" section in \"SQL Reference\" of the documentation too.\r\n\r\n\"The three ways to do inserts\" (or however more there are.....LOL!)\r\n\r\nScott"}}