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

• addSchema
• deleteSchema
• addResource
• alterResource
• dropResource
• alterRuleConfiguration
• alterDataSourceConfiguration
• alterSchema
• alterGlobalRuleConfiguration
• alterProps
• reloadMetaData

Calling setclass in fdbcli will try to change any process that matches the process filter given. If no processes are found, it silently does nothing. Instead, it should report back to the user that no processes matched the given filter.

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

Description

There are two logs that show the index backfill postgres connection's authentication key (password):

• a VLOG(1) in ConnectToPostgres that happens each call
• a LOG(WARNING) in ConnectToPostgres that happens only on bad connections

Ideally, this should not be visible in logs. It isn't a huge threat because, to use the auth key, you would need to use the yb-tserver-

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:

Adding an array element to an existing array inside the database without the need to select the array first and update the full array value afterwards.

CREATE TABLE t1 (id INTEGER, tags ARRAY(TEXT));
INSERT INTO t1 (id, tags) VALUES (1, ['database']);

UPDATE t1 SET
  tags = array_append(excluded.tags, 'search engine');
WHERE id = 1;

**Feature descr

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