Autosharding tests: Data manipulation

[donhardman]

• Ensure we can insert multiple rows into distributed data, and it's distributed across shards.
• Check that the data we inserted are returned in the select statement.
• Verify that we cannot alter or change the sharded table from the user side (only Buddy).
• Confirm that we cannot alter or change the replicated cluster from the user side (only Buddy).

[PavelShilin89]

@donhardman At the moment only insertion can be performed for this task. But maybe I found a bug in its work, I have given examples in #pavel-onboarding, the rest of the functionality is not working yet, it is not possible to test it. Please let me know when I can proceed with the issue and reassign it to me.

[donhardman]

While fixing a race condition issue in a multi-node environment, I introduced a bug yesterday. It should be fixed now and work as expected. Please check and let me know if it doesn't.

[PavelShilin89]

@donhardman I've done the first two items. Please explain in more detail what you mean in point 3 and 4.

If it is not possible to test everything specified in the task at the moment, I can merge what is already working and tested.
The rest can be placed in a separate task or you can specify what blocks its execution.

[donhardman]

The task has been split into two parts and can now be considered complete:

• Verify that we cannot alter or change the sharded table from the user side (only Buddy) #206
• Confirm that we cannot alter or change the replicated cluster from the user side (only Buddy). #207

[donhardman]

I've resolved the issue in Buddy that led to this bug after we addressed the double thread spawn. Please confirm that it's working now. Additionally, I discovered that the configuration for data validation is incorrect.

To handle data manipulation properly, we need to use sharding/inserts from Buddy.

Please double-check and add the required line to the config ONLY for data manipulation tests.

[PavelShilin89]

Done in manticoresoftware/manticoresearch#1828