distributed-database

What happened?

In a Jepsen test run of five etcd 3.5.3 nodes, with process pauses (sending processes SIGSTOP and SIGCONT), compaction (performed via the admin API), and defragmentation (via etcdctl), one etcd process crashed with the following error message:

{"level":"panic","ts":"2022-06-13T14:11:27.870Z","caller":"etcdserver/apply.go:638","msg":"unexpected error during txn","error

Enhancement

Actual:

mysql> CREATE TABLE t1 (a BINARY(16) PRIMARY KEY);
Query OK, 0 rows affected (0.02 sec)

mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
ERROR 1062 (23000): Duplicate entry '{ W]�u����.�٧t' for key 'PRIMARY'

Expected:

mysql> CREATE TABLE t1 (a BI

Is your feature request related to a problem? Please describe.
I'm trying to load maxmind database into cockroachdb.

Tutorial postgres at https://dev.maxmind.com/geoip/importing-databases/postgresql?lang=en, but because cockroachdb/cockroach#18846 is not supported yet.

Then I'm looking at tutorial on mysql https://dev.maxmind.com/geoip/importing-databases/mysql

Our CMake build process produces tarball packages using the cpack TGZ target. This produces a server and client package with a file layout meant to match where the various artifacts go.

Meanwhile, the packages we include on the download page are a flat archive of various binaries produced by the build process. This include one regular package and one debug package with debug symbols for a few

Jira Link: DB-2620

Description

Steps to repro -

• Setup xcluster replication between 2 universes with TLS ON and different certs.
• Start replication in demo1 table.
• Edit replication by adding demo2 table → fails.

Failing on 2.14, 2.15.0 and 2.15.1.

Platform Error message -

java.lang.RuntimeException: java.lang.RuntimeExce

The Trino codebase has (at the time of this writing) three PrintingLogConsumer classes:

• io.trino.plugin.deltalake.util.PrintingLogConsumer (logs information)
• io.trino.testing.kafka.PrintingLogConsumer (writes to a file)
• io.trino.tests.product.launcher.testcontainers.PrintingLogConsumer (writes to a file)

The PrintingLogConsumer classes from trino-testing-kafka and `trino-produc

Use case:

PosgreSQL client compatibility (e.g. Trino)
SQL compliance

CrateDB

CREATE TABLE doc.x (txt TEXT)
SELECT crate.doc.x.txt FROM crate.doc.x

PostgreSQL

postgres=# CREATE TABLE public.x (txt TEXT);
CREATE TABLE
postgres=# SELECT postgres.public.x.txt FROM postgres.public.x;
 txt 
-----
(0 rows)

[From PostgreSQL docs](https://www.postg

Enhancement

CREATE TABLE t_tf (
    a int not null,
    b float,
    c1 varchar(100)
) DUPLICATE KEY (id)
DISTRIBUTED BY HASH(id) BUCKETS 1;

To create a table as above, but id does not exist.
However, the error message is:
ERROR 1064 (HY000) at line 1: Key columns should be a ordered prefix of the schema.

1. the message is not correct.
2. it should display the

Description
Refactor EngineBuilder to remove duplicate code

Proposal
code:
https://github.com/CeresDB/ceresdb/blob/890fecf10848a3d09b485af52ff516deccf771fc/analytic_engine/src/setup.rs#L92
https://github.com/CeresDB/ceresdb/blob/890fecf10848a3d09b485af52ff516deccf771fc/analytic_engine/src/setup.rs#L120
https://github.com/CeresDB/ceresdb/blob/890fecf10848a3d09b485af52ff516deccf771f

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

Several showcase SQL requires the support of this function:


select DATE_FORMAT(b.measurement_time,'%Y-%m-%d') 

select DATE_FORMAT(FROM_UNIXTIME(tm.create_time), %Y%m%d)

Describe the feature you'd like