[Bug?]: Yarn shouldn't cache packages resolved with a file path

[wKich]

Self-service

• I'd be willing to implement a fix

Describe the bug

It's been a long time ago yarnpkg/yarn#2165 and the bug is still not fixed

To reproduce

1. Pack any package into tarball
2. Install it in different project
3. Do some changes in source code of the first package and pack it again
4. Install it one more time
5. See there are no changes made from the 3rd step

Environment

System:
    OS: Linux 6.1 Arch Linux
    CPU: (12) x64 12th Gen Intel(R) Core(TM) i5-12500
  Binaries:
    Node: 18.13.0 - /tmp/xfs-1122c5a5/node
    Yarn: 4.0.0-rc.35 - /tmp/xfs-1122c5a5/yarn
    npm: 8.19.3 - ~/.volta/tools/image/node/18.13.0/bin/npm

Additional context

No response