Hi all, I am not able to remove an entry from a linklist with a subselect instead by its @rid. How can I remove 'Linn' from 'MyCompany' in the following example if I only know the name?
CREATE DATABASE remote:localhost/test root root plocal CONNECT remote:localhost/test admin admin CREATE class company CREATE property company.name STRING CREATE class employee CREATE property employee.name STRING CREATE property company.employees LINKSET employee INSERT INTO company SET name = 'MyCompany' INSERT INTO employee SET name = 'Philipp' INSERT INTO employee SET name = 'Selma' INSERT INTO employee SET name = 'Thierry' INSERT INTO employee SET name = 'Linn' -- first we add all employees to the company UPDATE company ADD employees = (SELECT FROM employee) -- now try to remove the first 2 employees -> this works UPDATE #11:0 REMOVE employees = #12:0 UPDATE company REMOVE employees = #12:1 WHERE name = 'MyCompany' -- now we try to remove an emploee by its name -> this DOES NOT work and throws following exception: -- Error: com.orientechnologies.orient.core.exception.OCommandExecutionException: Error on execution of command: sql.select from company WHERE name = 'MyCompany' -- Error: java.lang.IllegalStateException: Object of classcom.orientechnologies.orient.core.sql.query.OResultSet can not be compared UPDATE company REMOVE employees = (SELECT FROM employee WHERE name = 'Linn') WHERE name = 'MyCompany' -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
