SQL

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create database db;
use db;
rename table tb1 to tb2;

2. What did you expect to see? (Required)

MySQL 5.7
ERROR 1017 (HY000): Can't find file: './db_optimistic/tb1.frm' (errno: 2 - No suc

Working on a project I ran into the documentation for customizing the Foreign Key.
The docs read:

// https://sequelize.org/master/manual/assocs.html
// For example, to use UUID as the foreign key data type instead of the default (INTEGER), you can simply do:

const { DataTypes } = require("Sequelize");

Foo.hasOne(Bar, {
  foreignKey: {
    // name: 'myFooId'
    type: D

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

Although RULE is not listed as an allowed privilege on https://www.postgresql.org/docs/current/functions-info.html it turns out that PG supports a query like this

select has_table_privilege('table'::regclass::oid, 'RULE')

Some tools rely on this. We can implement it in CRDB by always returning false, since CRDB does not have RULE privileges.

Instructions:

• Modify t

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.

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.

I merged refresher for Kernel and Federation in PR #13947 , and also removed some unit tests in PR #13950, but you can still refer to the previous code.

Now we need to add unit tests for the new implementation:

• AlterIndexStatementSchemaRefresher
• AlterTableStatementSchemaRefresher
• CreateIndexStatementSchemaRefresher
• CreateTableStatementSchemaRefresher
• Cre

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

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

When I try to connect dolt server using golang's go-sql-driver/mysql driver in multiple heads mode, It seems that go-sql-driver/mysql driver does't support database with a sub name. DSN string format in go-sql-driver/mysql like [username[:password]@][protocol[(address)]]/dbname[?param1=value1&...&paramN=valueN]. When dbname is "mydb", It works, but not work when dbname is "mydb/feature-branch".

This would allow the CLI to try connecting to a different node is the first node goes down.

Hi,

my admin portal looks like this :

Version

• Server Installed 1.38.4
• Server Latest 1.38.4
• Web Installed -
• Web Latest 2.17.1

It seems that, at some point, 'GetInstalledWebVersion()' in 'Admin.dll' is called? Could anyone help me understand what do I need to check, to fix this?

Hi all. Congrats for the amazing software :)

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

It would be amazing to have the IN operator available in this drop-down list:

Describe the solution you'd like

Have the IN oper

Describe the bug

When 2 tables joined on INT and LONG columns error shown that there is join column mismatch

To reproduce

select x, y
from long_sequence(100) ls
join (
  select cast(x as int) y from long_sequence(100)
) as ls2
on ls.x = ls2.y

Expected Behavior

INT can be be upcast to LONG and equality should be checked as LONG equality so that above query returns 10