SQL

Enhancement

mysql> CREATE TABLE t1 (
    -> risk_id varchar(32) NOT NULL,
    -> tran_id int NOT NULL,
    -> KEY (`risk_id`)
    -> );

mysql> CREATE TABLE t2 (
    -> risk_id varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
    -> -- risk_id varchar(32) NOT NULL,
    -> tran_id int NOT NULL,
    -> KEY (`risk_id`)
    -> );

mysql> explain select /*+ hash_join(t1) */ t1.ris

We already have some scripts in the scripts directory. It would be good to run them for every PR.
This is also a great task for beginners.

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

https://github.com/sequelize/sequelize/blob/8a1429d6044123bba3a3f312b2e0c74b0c829990/lib/model.js#L1271

If I create any model with
charset: 'utf8mb4', collate: 'utf8mb4_general_ci'

sequelize translates it to this for mysql

CREATE TABLE IF NOT EXISTS tablename ... ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8mb4_general_ci;

On stepping through the code, it seems that the issu

Is your feature request related to a problem? Please describe.

When debugging lease placement issues, it's instructive to look at the count for the number of raft leaders that aren't leaseholders. That metric however skips over replicas that hold invalid leases, which can mask the problem of a store holding a set of invalid leases and those leases not being actively acquired elsewhere. We s

Bug Description
fix issues found by Coverity Scan in TDengine/src/query/src/qFilter.c

To Reproduce
N/A

Expected Behavior
fix following issues:

Describe the Bug

It's not a huge bug, but...

Update a field, in other language than english, without access.

There is a mix beetween "current language", and internal message error.

To Reproduce

Modify roles of someone.
(in r

• Add fixture: JDBCRepositoryFixture implements JDBCRepository
• Add test case with mock

Currently we only support Upsert for CockroachDB. Implementing same for MySQL should be pretty straightforward as well.

Wonder if we can also use INSERT ON CONFLICT UPDATE for PostgreSQL to ensure operation with same signature also works.

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

• All unquoted column names are treated as upper case
• Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

The dolt logo is inspired by a commit hash d01t.

It would be cool if we had an option to have a dolt initial commit be rerolled until the first four characters matched the following pattern:

1. d, o l, t in order
2. any uppercase or lowercase d, o, l, t
3. 0 or 1 can replace l or t

I think this should be a hidden option not in the docs.

Issue description

This option will improve performance in many scenarios
https://dev.mysql.com/worklog/task/?id=8134

https://www.facebook.com/weixiang.zhai/posts/678596755543802

Is your feature request related to a problem? Please describe.
with the implementation of copy to clipboard it would be very useful to have the option to copy with this pattern below (which I don't remember the name at this time)

Describe the bug

In the documentation, it is written that we can get the day of year using the to_str(time, 'D') approach. However, using the latest docker images, this will return the string 'D' as a result. See https://questdb.io/docs/reference/function/date-time/#date-and-timestamp-format

I assume this may be tracked down somewhere around here, where the capital D is never being regist

설명

퀵 정렬 게시글 중 bold 설정이 일부 들어가지 않았습니다.

링크

1. gyoogle - 퀵 정렬 (최악의 경우)
2. gyoogle - 퀵 정렬 (공간복잡도)

스크린샷

1. <img width="600" alt="image" src="https://user-images.githubusercontent.com/57972338/161484958-416f6d20-33df-412a-a5ca-c72f7