Baur

Maybe related https://github.com/crate/support/issues/386#issuecomment-2066259170

Hi @seut, could you please check current draft? There are still docs missing and need to write full blown integration test but otherwise functional is ready.

Pushed another [commit](https://github.com/crate/crate/pull/15551/commits/5b8559a194c174ca3017db4d9c74a3ef39b0bfba) to resolve Algorithm not from header but from JWK endpoint.

Hi @seut, @mfussenegger, PR is ready for another review. One thing which might need a closer look - checking token per request. If token issuer adds and signs "exp" claim...

unrelated https://jenkins.crate.io/job/CrateDB/job/crate_on_pr/13243/testReport/junit/io.crate.integrationtests/LogicalReplicationITest/test_drop_and_recreate_subscription_while_published_table_is_written_to/ retest this please

another one LR failure https://jenkins.crate.io/job/CrateDB/job/crate_on_pr/13244/testReport/junit/io.crate.integrationtests/LogicalReplicationITest/test_write_to_subscribed_empty_partitioned_table_is_forbidden/ retest this please

> Tried git bisect and #14911 is found to be the cause. Will double check and proceed. This change is related only to inserts. Also, the first high spike happens...

regarding first regression - looks like https://github.com/crate/crate/commit/df3d28ed7bd2d466a8ce13e8be427fe89acefcb6 is the only relevant to joins commit between 25.10-01.11

> update: done more investigations, I think we now have an extra fetch which causes the degradation. This is most likely related to https://github.com/crate/crate/pull/15227#discussion_r1433977031. ==> related to > There is...

dev-cluster https://tools.cr8.net/grafana/d/-8PNA2vnz/cratedb-dev-cluster-benchmarks?orgId=1&var-spec_file=outer-joins.toml&var-statement=select%20e.name%20as%20employee,%20o.name%20as%20office%20from%20employees%20e%20full%20join%20offices%20o%20on%20e.office_id%20%3D%20e.id%20limit%2050000&var-concurrency=1&from=now-6M&to=now caught by crate-alerts https://github.com/crate/crate-alerts/issues/608, mean got slightly higher from the end of August