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

Some system variables either have no type (default: TypeString) or use TypeString when they could use a different builtin type (TypeInt, TypeEnum, TypeBool) that is more suited. Here is what I found from manual inspection:

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 

Hi community,

This issue is for WeOpen-Star

We need to add more unit test for DatabaseTypeEngine.

• DatabaseTypeEngine#getProtocolType
• DatabaseTypeEngine#getStorageType
• DatabaseTypeEngine#getDefaultSchemaName

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

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

dev=> create table t (v int);
CREATE_TABLE

dev=> drop materialized view t;
ERROR:  Invalid input syntax: Use `DROP TABLE` to drop a table.
dev=> drop source t;
ERROR:  Invalid input syntax: Use `DROP TABLE` to drop a table.

dev=> create materialized view mv as select * from t;
CREATE_MATERIALIZED_VIEW
dev=> drop table mv;
ERROR:  Invalid input syntax: Use `DROP MATERIALIZED VIEW`

Refactoring request

Rename the namespace starrocks::vectorized to starrocks for codes under be/src/storage.

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