Merged PRs
dolt
- 6250: fixes infinite loop related
- 6249: Fix for cherry-pick docs and PK mapping error message
- Update cherry-pick docs now that schema and data conflicts are supported in cherry-pick.
- Fix a bug in schema.go where the incorrect column name (
Invalid
) was being printed out due to a shadowedcol
variable.
- 6244: dolt clone: Fix dolt clone run against a sql-server where the database has been GCd.
A long-standing bug in the remotesapi which the sql-server exposes could cause adolt clone
to fail when running against a database which had been garbage collected. This change fixes the bug in the server. It also patches the client behavior so that it will tolerate responses from older versions of dolt. - 6243: Fix dolt status formatting
dolt status
output was missing some new linestaylor@MacBook-Pro-3 test % dolt status On branch main Your branch is ahead of 'origin/main' by 1 commit. (use "dolt push" to publish your local commits)Changes not staged for commit: (use "dolt add <table>" to update what will be committed) (use "dolt checkout <table>" to discard changes in working directory) modified: table1 taylor@MacBook-Pro-3 test % dolt status
taylor@MacBook-Pro-3 test % dolt status On branch main Your branch is up to date with 'origin/main'.nothing to commit, working tree clean
- 6242: adds print statements for errors in commit
adds missing print statements for errors occurring indolt commit
- 6240: Add global arguments section to dump-docs command
- 6221: Migrate
dolt diff
anddolt show
to SQL implementation
This change migrates the currentdolt diff
implementation to use only SQL.
This is done by offloading most of the diffing logic todolt_diff
anddolt_schema_diff
table functions, and making some of the common code generic, so we don't have to rely on DoltDb objects (which rely on dolt internals).
This change also partially migratesdolt show
to SQL.
dolt show
has the ability to log some of the storage internals in two cases:--no-pretty
flag is specifieddolt show
is invoked against non-commit hashes
When either of the above cases occurs, we use DoltEnv to get these structures and log them. In all other cases, we use SQL to get the list of changes.
Closed Issues
- 6230: Stored procedure includes results from
SET
statements - 4204: Set commit message and author while using
@@dolt_transaction_commit
- 3521: Multi-database state syncing in transactions
- 5933: DBeaver does not remove tables correctly when database isn't specified in connection
- 3789: Loosen identifier validation to match MySQL
- 4885:
SAVEPOINT
fails if database is not selected. - 5042: Dolt allows creating trigger in not current schema
- 5314: USE
database/branch
broken for write statements - 5364:
mysql
system db isn't "use"able via sql-server - 5816:
call dolt_checkout(<table>)
does not work for revision databases
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 1.93 | 2.71 | 1.4 |
groupby_scan | 12.52 | 16.71 | 1.3 |
index_join | 1.18 | 4.33 | 3.7 |
index_join_scan | 1.12 | 2.07 | 1.8 |
index_scan | 30.81 | 54.83 | 1.8 |
oltp_point_select | 0.14 | 0.46 | 3.3 |
oltp_read_only | 2.81 | 7.98 | 2.8 |
select_random_points | 0.29 | 0.75 | 2.6 |
select_random_ranges | 0.35 | 1.08 | 3.1 |
table_scan | 30.81 | 55.82 | 1.8 |
types_table_scan | 69.29 | 161.51 | 2.3 |
reads_mean_multiplier | 2.4 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 4.82 | 6.09 | 1.3 |
oltp_insert | 2.52 | 2.91 | 1.2 |
oltp_read_write | 6.21 | 15.0 | 2.4 |
oltp_update_index | 2.48 | 2.97 | 1.2 |
oltp_update_non_index | 2.39 | 2.97 | 1.2 |
oltp_write_only | 3.49 | 7.43 | 2.1 |
types_delete_insert | 5.28 | 6.55 | 1.2 |
writes_mean_multiplier | 1.5 |
Overall Mean Multiple | 2.0 |
---|