Marios Trivyzas

Hi @juanpardo ! Thx for reporting the issue. The queries won't show in `sys.jobs` (and therefore `sys.jobs_log`) until they start executing, (we'll discuss if there should be a change in...

More info was shared privately by @juanpardo, thx!

Simpler reproduction: ``` CREATE TABLE IF NOT EXISTS t ( "a" TEXT NOT NULL, "b" TEXT NOT NULL, "c" TEXT NOT NULL, PRIMARY KEY ("a", "b", "c") ); ``` query:...

The issue with ugly `ArrayIndexOutOfBounds` error can simply be reproduced with: ``` SELECT * FROM t WHERE a = ? AND b = ? AND c = ? ``` since...

@juanpardo Thx a lot for reporting this issue. The part regarding the ugly exception has been fixed and will be available with the next hotfix release. Additionally, I discovered the...

The `INSERT INTO` plan (unlike the plain query) uses ` PlanHint.PREFER_SOURCE_LOOKUP` which seems to dramatically impact the performance in this case. On my machine the Insert takes ~`1.5 sec`, if...

Another related optimization is: https://github.com/crate/crate/pull/15728 It could also make sense to consider tackling this after implementing cost based planner: https://github.com/crate/crate/issues/14146

This has to do with inlining optimizer hints to queries, the PlanHint I referred to is something internal currently. We can also consider exposing this as a session setting, similar...

Thank you for looking into this! Maybe then you could check if we can eliminate (or improve) this devation between runs, maybe adding a limit to the subquery or so?

Hi @kotlalokeshwari098. First of all, thank you for your interest in contributing to CrateDB. I'd like to let you know that this issue can be rather complex, and maybe it's...