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

There are several optimization the execution engine can perform when evaluating LIKE patterns with %, which matches zero or any number of any character. For example, see #80073.

Sequential %s can prevent these optimizations, but they are semantically equivalent to a single %, so the optimizer should normalize them to a single %.

For example:

-- The following expressions 

The methods need to be tested:

• getAttributes
• getIp
• getUniqueSign

Do not forget reset the COUNTER after test cases run

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:

Get the total duration over many events. Something like select sum(age(ended, started)) from myevents or select sum(ended - started) from myevents - depending on crate/crate#12479

See https://github.com/crate/crate/blob/dc3ce297b1597d482949a2e57479890feb3adbf4/server/src/main/java/io/crate/execution/engine/aggregation/impl/SumAggregation.java#L67

Describe the bug
A clear and concise description of what the bug is.

The compute node crashed on an unsupported expr.

hread 'tokio-runtime-worker' panicked at 'not implemented: The expression (Interval, Int32, Interval) using vectorized expression framework is not supported yet!', src/expr/src/expr/expr_binary_nonnull.rs:399:13
stack backtrace:
   0: rust_begin_unwind
          

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

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