Umbraco-cms: v7.15.4: User sees an unrelated and unloaded node in backend

[Myronics]

Issue

When logged in the backend, the user has acces to an extra (unloaded/disabled) unrelated node.
This seems to happen when the starting digits of the two nodeId's are identical but at least one order of magnitude apart.

In our case the nodeId's were 1119 and 11194 respectively.

Umbraco version

I am seeing this issue on Umbraco version: 7.14.5

Reproduction

Steps to reproduce
In Umbraco's backend:

1. Create a new node that has the same starting digits as another node
2. Login with the user attached to this node

Screenshots
Backend:

Rights:

Expected result
User has acces to one node: 'community idtest2'

Actual result
User has acces to two nodes: 'community idtest2' and '17 - Community'

[nul800sebastiaan]

Wow that's interesting, it's probably because we're doing some query where the path of the node starts with (something like SELECT x FROM umbracoNode WHERE path LIKE 0,1119%).

We'd love some help getting it fixed if you or someone coming along can have a look at it!

[umbrabot]

Hi @Myronics,

We're writing to let you know that we would love some help with this issue. We feel that this issue is ideal to flag for a community member to work on it. Once flagged here, folk looking for issues to work on will know to look at yours. Of course, please feel free work on this yourself ;-). If there are any changes to this status, we'll be sure to let you know.

For more information about issues and states, have a look at this blog post

Thanks muchly, from your friendly Umbraco GitHub bot :-)

[ingriT]

Hi! I'm a coworker of Myronics, so I took a shot at fixing this.

Could someone (@nul800sebastiaan)? take a look at my PR? Did I submit it correctly?

Thanks!