Delete query does not work correctly [moved]

[lvca]

This is Issue 98 moved from a Google Code project.
Added by 2010-08-13T07:33:09.000Z by emailmat...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.
Closed (Invalid).

Original labels: Type-Defect, Priority-Medium

Original description

<b>What steps will reproduce the problem?</b>
I used the SQLDelete example (http://code.google.com/p/orient/wiki/SQLDelete), but got an exception.

<code>db.query(new OSQLSynchQuery<ODocument>(&quot;delete Address where type = 'Residence'&quot;));</code>

<b>What is the expected output? What do you see instead?</b>
That all the records with type Residence are removed from the database. But instead I see the following exception:
<code>Exception in thread &quot;main&quot; com.orientechnologies.orient.core.exception.OCommandExecutionException: Error on execution of command: OSQLQuery [text=delete Address where type = 'Residence']
-> com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing query at position #6: Missed FROM
Query: select  Address where type = 'Residence'</code>

<b>Please use labels and text to provide additional information.</b>
SQL, DELETE, query