Tim Sehn

Expecting Indexed JOINs. Got Inner JOINs.

2

Simple Repro: https://www.dolthub.com/repositories/learn-sql/lesson-1/query/master?q=explain+SELECT+first_name%2C+last_name%2C+dept_name%0AFROM+%60employees%60+NATURAL+JOIN+employees_departments+NATURAL+JOIN+departments%3B%0A%0A&active=Tables

`dolt diff` should support `--filter` option

4

`--filter` could be arbitrability complex but I think we start with `` as the first options accepted. This option filters the diff down to modifications of those types. This is...

`dolt diff --sql` may be used to build simple patches for databases that are no MySQL. Backticks are not universally supported as part of standard SQL. For instance PostgreSQL pukes...

When working on my Django example app I needed to use the `dolt_branches` table. I noticed it advertises it's text fields as `text` type. ``` mydatabase/main> describe dolt_branches; +------------------------+----------+------+-----+---------+-------+ |...

Messaging on a merge where a table was altered and deleted on each side of the merge not helpful

3

Repro: ```bash $ mkdir test_schema_merge $ cd test_schema_merge $ dolt init Successfully initialized dolt data repository. $ dolt sql -q "create table a (pk int)" $ dolt sql -q "create...

Improve Dolt sysvar support

2

There are many MySQL of system variables like `@@max_user_connections`, `@@max_connections`, `@@port`. A full list can be found here: https://dev.mysql.com/doc/refman/8.0/en/dynindex-sysvar.html Dolt does not set many of these and for some returns...

Update triggers do not fire on `dolt table import -u`

4

Repro. As you can see insert triggers fire just fine. ``` $ dolt init --fun Successfully initialized dolt data repository. $ dolt sql -q "create table t (pk int primary...

Dolt History Compression

1

Dolt can grow large in disk space over many commits. Dolt stores a copy of indexes for every commit. Foreign keys in particular generate lots of indexes. We may want...

Merging main into another branch breaks `dolt_diff_<table>`

5

Repro ``` $ dolt init --fun Successfully initialized dolt data repository. $ dolt sql -q "create table xy (x int primary key)" $ dolt commit -Am "new table" commit 44oi6heb4fcikr0cffg2bcvnjnn0qh7k...

Indexes not performant for in-memory implementation

1

When using the in-memory implementation, Index syntax will parse but there will be no indexes on the tables. The backend is not implemented. This may cause weird ordering or other...