James Cor

Currently, all users show up when running `select * from mysql.user`, assuming you have select privileges on mysql. One of these users is a superuser (can be specified through `--user`,...

Steps to reproduce: ``` tmp_db> create table mytbl (i int); tmp_db> create table seqtbl (x int); tmp_db> insert into seqtbl values (1000); Query OK, 1 row affected tmp_db> create trigger...

Closes https://github.com/dolthub/dolt/issues/2475

In MySQL, CTEs that reference other CTEs can only see the ones to the left ``` mysql> with c as (select * from b), b as (select * from a),...

Auto Increment increments despite error

2

When an insertion fails, a column defined with `auto_increment` still increments the value. Repro: ```shell test_db> create table t (i int primary key auto_increment, j int not null); test_db> insert...

Prevent altering table tables to have `FULLTEXT` key property

1

We don't support FULLTEXT keys, yet, so we should prevent altering tables to have them. These two queries should return an error: ```shell dolt> create table t (a int primary...

`SHOW PROCEDURE STATUS` is always current time

1

Regardless of when a PROCEDURE is created, the `MODIFIED` and `CREATED` time for is always the current time.