dolt
dolt copied to clipboard
Dolt – Git for Data
I have a long running server process to process the wikipedia import. I build `dolt` from main every day or so. I use the `dolt` CLI to connect to the...
MySQL: ``` mysql> select cast(JSON_OBJECT('key"with"quotes', 1) as char); +--------------------------+ | cast(@a as char) | +--------------------------+ | {"key\"with\"quotes": 1} | +--------------------------+ 1 row in set (0.00 sec) mysql> select cast(cast(JSON_OBJECT('key"with"quotes', 1)...
In MySQL, when a column is dropped, it is removed from any indexes that use it. Dolt currently has a different behavior – when a column is dropped, any indexes...
This is mainly a shot in the dark regarding the shallow clone failures in CI. I changed the port number based on a hunch. The remotesrv process now has a...
We should have a `dolt_help` system table with the following schema: target (key): ie. dolt_checkout, dolt_diff, dolt_hashof, etc type: system table, procedure, function, variable short description: the short help text...
I believe this used to work, but getting a diff between STAGED and WORKING using the `dolt_commit_diff_[tablename]` system table currently fails (dolt v1.39.3). For example, ```sql SELECT * FROM `dolt_commit_diff_tablename`...
Dolt currently supports creating stored procedures, but does not yet support creating user-defined functions. Stored procedures allow customers to execute custom SQL code, but not directly return results that can...
According to the MySQL documentation for JSON paths (https://dev.mysql.com/doc/refman/8.4/en/json.html): - [N] appended to a path that selects an array names the value at position N within the array. Array positions...
`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...
With local backup and restore feature, dolt returns empty reflog (no commits, branches or tags are returned). If you make a new commit, reflog returns, but still some entries are...