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

In a support escalation (https://github.com/cockroachlabs/support/issues/1709) for a v21.1 cluster, we saw that leaked gossip entries could impact foreground latency. The gossip leak itself has [since been fixed](cockroachdb/cockroach@d07b32db3e49e

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

I've got a bizarre behavior using Flows and Webhook / Request URL operation (https://docs.directus.io/configuration/flows/operations/#webhook-request-url)

If I put in the Request body {{ $trigger}}

the content-type of the request is **applica

• 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