James Cor

Hi, I work for DoltHub, the maintainers of Dolt, a version controlled database (think Git and MySQL had a baby). This is shameless self-promotion, but we took the liberty of...

have default collation be `utf8mb4_0900_ai_ci`

3

By default, MySQL's collation is `utf8mb4_0900_ai_ci` https://dev.mysql.com/doc/refman/8.0/en/charset.html#:~:text=The%20default%20MySQL%20server%20character%20set%20and%20collation%20are%20utf8mb4%20and%20utf8mb4_0900_ai_ci Dolt has it set as `utf8mb4_0900_bin`. As a result, we have to set the collation through `@@collation_connection` (`@@persist.collation_connection` if you want it to...

`ALT + TAB` breaks dolt shell in Windows CMD

4

Steps to repro: 1. Launch Windows CMD 2. `dolt sql` 3. type some stuff 4. ALT + TAB away 5. ALT + TAB back 6. Terminal now behaves as if...

This parses in MySQL, but throws syntax error in dolt. ```sql mysql> create table t (i int); Query OK, 0 rows affected (0.0241 sec) mysql> insert into t values (1);...

In MySQL, string comparisons just ignore the `NUL` character (`'\0'`) ```sql mysql> select '123' = '123\0'; +-----------------+ | '123' = '123\0' | +-----------------+ | 1 | +-----------------+ 1 row in...

`DESCRIBE` queries over tables that do not have `primary keys` mark the columns that have `NOT NULL` constraint and are part of the first unique key/index as `PRI`. However, dolt...

TODO: this is only supposed to work on `TIME` literals. Otherwise, it just returns `NULL`

MySQL: ``` mysql> create table t (i int, j int); Query OK, 0 rows affected (0.0187 sec) mysql> insert into t(i, j) values (); ERROR: 1136: Column count doesn't match...