Nick Tobey
Nick Tobey
Ignored tables are tables that exist at in the working set that are never staged. Commands should typically ignore them. `dolt cherry-pick --abort` should reset the branch to the state...
This is to be consistent with how git handles .gitignore. This behavior is described in the original PR (https://github.com/dolthub/dolt/pull/5809), but as far as I can tell was never actually implemented...
One of our plan tests looks like this: ``` "create table vals (val int unique key);", "create table ranges (min int unique key, max int, unique key(min,max));", "insert into vals...
In MySQL, the JSON datatype is allowed to wrap data that does not typically appear in JSON, including other builtin types like decimals, datetime, etc. Dolt appears to coerce these...
Dolt appears to not parse the date or time literal syntax. It *does* parse a datetime literal, but the result is... odd. MySQL: ``` mysql> select date '2012-12-31'; +-------------------+ |...
MySQL: ``` mysql> select CAST(CURRENT_DATE as JSON); +----------------------------+ | CAST(CURRENT_DATE as JSON) | +----------------------------+ | "2023-12-20" | +----------------------------+ 1 row in set (0.00 sec) ``` Dolt: ``` json> select CAST(CURRENT_DATE...
Reproduction steps: ```sql CREATE TABLE test(j json); INSERT INTO test VALUES (JSON_OBJECT("a", 1.0)); SELECT * FROM test; SELECT * FROM test WHERE j =JSON_OBJECT("a", 1.0); ``` MySQL output: ``` mysql>...
The MySQL spec requires that JSON objects have an ordering, but this ordering is implementation defined. Dolt has a comparison function for JSON objects, but it's not well ordered. ```...
This is a bit tricky to reproduce, unlikely to affect any real-world use case, and does not cause correctness issues. But it can influence table hashes, which means it can...
Reproduction steps: ```sql CREATE table xy (x int primary key, y int, unique index y_idx(y)); insert into xy values (1,0), (2,1), (0,2), (3,3); select y as z from xy group...