LMDB query optimization is wrong for particular queries/data sets

[kenwenzel]

Current Behavior

As discussed in this conversation https://github.com/eclipse/rdf4j/discussions/3953 the LMDB store seems to compute wrong cardinalities for particular queries and/or data sets resulting in unacceptable query execution times.

Expected Behavior

The query optimizer should deliver the same results for the LMDB store as for the MemoryStore or NativeStore.

Steps To Reproduce

No response

Version

4.0.1

Are you interested in contributing a solution yourself?

Yes

Anything else?

No response