MySQL

Currently, in provisioning, we always update structs if they already exist. This introduces some load to the database. In the future, we would like to have a function that compares the internal state with the external state.

• Alert rules
• Contact points
• Templates
• Mute timings

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

Please enter the following details

Copy and Paste Project Info - Tutorials: How to check my Project info? (YouTube Tutorial or Documentation)

Node: **v16.13.2**
Arch: **x64**
Platform: **darwin**
Docker: **false**
Database: **sqlite3**
ProjectOnRootDB: **true**
RootDB: 

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

When browsing wide data tables in the dashboard (which I do a lot) it is very inconvenient because the browser's horizontal scrollbar is hidden unless you scroll to the very bottom of the page.
If I am at a page like /console/data/schema/public/tables/[tablename]/browse

I won't be able to scroll the table right (to see other columns) unless I first scroll vertically to the bottom of the page

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

Bug description

On windows, I run prisma format and note the unusual file ending. The lines are all LF, but the very last line is CRLF.

This causes issue on my Linux CI where it formats it ending in LF's only, causing a diff to occur and the build to fail.

How to reproduce

1. On windows do prisma format
2. Open in HxD or similar
3. See attached:

![image](https://user-images.g

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.

Our parser outputs all aggregations functions using the general sqlparser.FuncExpr. This is a little clunky and requires us to do additional checks before we are sure that the aggregation we have is valid and what it is aggregating.

I suggest we instead introduce one struct type per aggregation, and have them all implement some interface. This would help clean up the code.

Example:

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)