How to define number of shards and replicas? about crate-dbal

[seut]

@nook24 Thanks for reporting the missing support for custom CrateDB table options.
I've created a PR to add this.

We'll look into the PK issue next.

[seut]

@nook24 We cannot reproduce the PK issue on $SchemaManager->createSchema();, we also have a test for validating the functionality using a primary key, see https://github.com/crate/crate-dbal/blob/master/test/Crate/Test/DBAL/Functional/Schema/SchemaManagerTest.php#L117.

Could you please paste us your used table schema?

[nook24]

Hi @seut, many thanks for looking into this. This is the schema I used: https://github.com/statusengine/worker/blob/master/lib/crateDB.sql

Maybe this issue is caused by the multi field primary keys

[seut]

@nook24 Thanks for the information. We've figured out that the issue is not related to tables with primary key constraints but related to tables without any.
We're working on a fix, I'll keep you updated.

[seut]

@nook24 We've fixed the issue which will be part of the next release.
Thanks for bringing this up.

[seut]

@nook24 We've released v2.1.0 including the PK fix and table options support.

[nook24]

Many thanks for your fast fix! I will test it :)