Skip to content

Update Query Not Reflecting Changes in Linked Records #10077

@Aniket-Lonare

Description

@Aniket-Lonare

OrientDB Version: 3.2.26

Java Version: jdk11

OS: Linux ( Docker image)

Expected behavior

The expected behavior is that the data should be updated successfully when executing the linked query.

Actual behavior

Despite receiving a response indicating that the record has been updated, the actual data remains unchanged.

Steps to reproduce

  1. We have a class named "States" with three properties: ID, Name, and Hidden. Hidden is a Boolean property.

  2. We also have another class named "Objects" with four properties: ID, Name, Hidden, and State. The "State" property is linked to the "States" class, and the "ID" property is indexed with the following configuration:

    Index for "ID" property:
    CREATE INDEX Objects.ID ON Objects (ID) UNIQUE_HASH_INDEX ENGINE HASH_INDEX
    
  3. Attempting to update the information of a "States" class object using the following query:

    Update Objects set Hidden = true, States.Hidden = true return after States:{*} as StateInfo where ID = "1234"
    
  4. After executing the query, the hidden property from the "States" class appears to be updated in the result. However, when fetching the record using the ID of the "States" class, it is observed that the update is not reflected.

The above query was working in the 3.2.24 version.
Please let me know if you need any more information to look into this issue.

Thank you.

Metadata

Metadata

Assignees

Labels

buglegacy not used anymore

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions