DROP PROPERTY Problem #1401

Closed
junnel1001 opened this Issue Mar 20, 2013 · 1 comment

Comments

Projects
None yet
4 participants

Hello,

My Database is in partial-mode schema.

When I query accidentally like this

UPDATE class_name set following.rid = "Hello"

It created a property in my class now "following.rid"(which is supposedly not and should return an error since that property name is not valid).

Now I want to drop this property because it is so annoying.

But as expected it returns an error since first of all following.rid is not a valid property.

This is my DROP property syntax:

DROP PROPERTY class_name.following.rid

returns:

Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #39: Expected .. Use DROP PROPERTY .
Command: DROP PROPERTY class_name.following.rid

Can you please check this one? thanks.

laa was assigned Sep 17, 2013

lvca removed the bug label Apr 8, 2015

lvca added the bug label Jan 12, 2016

Contributor

luigidellaquila commented Mar 11, 2016

This is an old issue, it is not valid anymore in current release.

Anyway:

  • the UPDATE does not create a property in the schema, it just inserts data.
  • that statement does not create a property called "following.rid", it creates a "rid" property in the "following"
  • in v 2.2 you can use back-tick quoting to support dots in property names, eg.
UPDATE class_name set `following.rid` = "Hello"
CREATE PROPERTY class_name.`following.rid`
DROP PROPERTY class_name.`following.rid`

Closing

Thanks

Luigi

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment