SQL

Enhancement

We have many place to use the exp/slices to sort our struct. It can improve performance by using pdqsort and clean branch check. But We have many placement using the old sort. Please remove it. Here is the example .

BTW, You haven't to change the bazel.build. it can be updated by robot.

• #36061
• #360

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

We have metrics recoding flush related stats (number of flushes, duration), but
those only work when issuing explicit Flush request.

Some sinks (cloud storage) also flush based on other criteria (size) -- we should
add metrics to record those flushes as well.

Jira issue: CRDB-17659

Bug Description
fix issues found by Coverity Scan in syncMain.c

To Reproduce
N/A

Expected Behavior
fix following issues:
| issue type | category | file path | function | line number |
| -------------------------- | -------------------------- | -------------------------- | -------------------------- |

Describe the Bug

if you set AUTH_DISABLE_DEFAULT to true and define an LDAP AUTH_PROVIDER, the login form will be empty.

this is caused by driver never being assigned to the ldap value: https://github.com/directus/directus/blob/64acd2fdb32103761b7f8ed1a195ef4412db00cc/app/src/routes/login/login.vue#L52

before, on setup, providerOptions would always be set, calling the comput

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

Using dolt sql -q "<query>" -r csv > file.csv results in newlines in the output data:

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

every time I lost the connection, (usually got closed from server side due to long time idle) I have to restart the application to reconnect to database, otherwise I can't query anything

should be able to keep the connection alive, check if the connection valid and do the reconnect thing automatically and periodically.

Is your feature request related to a problem?

We have users periodically asking for week-based partitioning.

Describe the solution you'd like.

Add WEEK to the PARTITION BY options.

Describe alternatives you've considered.

No response

Additional context.

This PR should give enough hints on how to implement this feature: questdb/questdb#1571

As a result of the showcase, we should improve the following messages:

• “column does not exist”: Which one?
• “syntax error: unexpected IDENTIFIER”: Would like to
• have a hint where to look for the error in my statement.
• "pq: syntax error: unexpected $unk"