Marios Trivyzas

It sounds like a valid point, thx for explaining it further!

Thx for your interest @RichardIcecube, the class you want to check is `SysSnapshotsTableInfo` , there you can see that the method to adjust is `SysSnapshot#tables()`

no worries @RichardIcecube, and apologies, I shouldn't have rushed to put the `good first issue` label on this, as this needs first some more careful thought.

The functionality from a user's perspective is correct, this issue tracks an optimization. When we select with the same filter the optimizer constructs a `Get` plan because of the `id...

To make it 100% clear, with select when filtering on pk AND some other columns it works with a `Get` plan, therefore accessing the translog and getting results without refresh:...

We have some concerns, as if we implement this for the currently supported Updates/Deletes, we might end up with inconsistent behavior in the future, if we introduce Updates/Deletes by complex...

As a high-level thought, LogicalPlanner and Optimizer boundaries are gray for Joins. Maybe we should come up with a LogicalPlan that is built by the planner as a 1st step,...

Additionally, I still see an issue: Conceptually (and ideally), LogicalPlanner should build a completely unoptimized plan, which can be executed, but this plan should also contain all the necessary structures...

Hi @theartpiece, thank you for the interest in contributing to CrateDB. Please don't post your interest on a bunch of issues, but rather pick one that interests you, so that...

@DHRUV6029 Thx for volunteering to work on this! Please let us know of any help you might need.