distributed-database

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create database db;
use db;
rename table tb1 to tb2;

2. What did you expect to see? (Required)

MySQL 5.7
ERROR 1017 (HY000): Can't find file: './db_optimistic/tb1.frm' (errno: 2 - No suc

Although RULE is not listed as an allowed privilege on https://www.postgresql.org/docs/current/functions-info.html it turns out that PG supports a query like this

select has_table_privilege('table'::regclass::oid, 'RULE')

Some tools rely on this. We can implement it in CRDB by always returning false, since CRDB does not have RULE privileges.

Instructions:

• Modify t

We create a number of threads in various places in our code, and in most cases we do not give these threads names. It could be helpful to have names that make it easier for us to see what a thread is doing. Some examples include:

1. The network thread created by bindings (some bindings name this thread, others do not)
2. External network threads (name proposed in #6033)
3. Trace logging threa

This would allow the CLI to try connecting to a different node is the first node goes down.

Description

Currently, for e.g. say that out of 3 copies of a tablet, we want to have 2 copies in C1.R1.Z1 and 1 copy in C2.R2.Z2 then we would specify it as below:

./bin/yb-admin \
    -master_addresses $MASTER_RPC_ADDRS \
    modify_placement_info  \
    C1.R1.Z1,C1.R1.Z1,C2.R2.Z2 3

However, this is somewhat complex and hard to follow. We don't need to necessarily r

We should use MockConnector to simulate connector that support missing columns on insert and test if row filtering is properly handled if columns are missing during the insert but used in row filters.

Related to: #10006 and #10005

Use case:
Add the ability to search for an element in an array and retrieve back the array index.
As per the PostgreSQL documentation:

array_position ( anycompatiblearray, anycompatible [, integer ] ) → integer

Returns the subscript of the first occurrence of the second argument in the array, or NULL if it's not present

Currently we don't have any mechanism to limit the maximum number of clients that could be handled simultaneously.

This feature should be designed properly. Here is some clue: https://redis.io/topics/clients#maximum-number-of-clients

Now that we support more than 1 data type, we should include the values data type in cache nodes. This give us a way of easily identifying what type of data a key points to e.g. string, queue (and more types in the future)

Currently a cache node object consists of a Key, a Value and a TTL. We should also add a field specifying the type of the Value