Merged PRs
dolt
- 5084: update maven version
- 5064: adding --set as valid flag for dolt config
Adds--set
as a valid flag fordolt config
.--set
does the same as--add
.
fixes: #5050 - 5061: gms bump for merge join
GMS PR: dolthub/go-mysql-server#1499 - 5049: fix panic for
select active_branch()
on revision db
fix for: #5043
it errors now - 5048: docs(README): add info about sql command
changes:
- make an sql
- note that this is an sql command
- note that the exactly steps done later
why:
- i was typing
dolt create database
and got error ... and searched what is the right syntax fordolt
command to make the step "create an database" at this point - but this was not nessesary at this point, because its explained later
suggestion:
- remove this lines or do a better rewording, so that an user not think he need to do here something.
Note:
added also this PR for the docs: dolthub/docs#1095 - 5039: Use session-level transactions
Incidentally also re-implements database session initialization - 5037: makes batching default for dolt dump
Currentlydolt dump
only batchesINSERT
statements when the--batch
flag is included. This change flips the behavior to default to batchingINSERT
statements with the--batch
flag now turning off this behavior.
fixes: #4954 - 4969: Removed deprecated dolt functions
go-mysql-server
- 1511: Fix nested subquery expression caching regression
- 1507: typos
- 1505: Bug fix for null handling in group by
Fixes: dolthub/go-mysql-server#1503 - 1504: Rewrote readme and related docs
- 1502: add support for features and feature collection for geojson
make ourst_geomfromgeojson()
parse formats that contain typeFeature
andFeatureCollection
reference: https://www.rfc-editor.org/rfc/rfc7946 (sections 3.2 and 3.3) - 1499: merge join
dolt bump: #5061 - 1498: /{go.sum, sql}: allow time conversions for golang zero time
https://go.dev/play/p/nzS0vAAI5yd
remove call oftime.IsZero()
to allow0001-01-01 00:00:00
as valid datetime. - 1494: add 'privileges' column for
information_schema.columns
table
Madeinformation_schema
database and its tables accessible to all users.
Note:- column privileges is not supported yet.
- view columns not supported yet.
- 1489: Greatly simplified stored procedure analyzing and variable referencing
Practically everything is implemented using interfaces now, so we're not special casing every node that has some sort of "divergent" behavior from a standardsql.Node
. Additionally, instead of associating every variable with a global id, there's a sort of stack implementation using nested scopes while executing a stored procedure. This simplifies analysis (the step assigning ids now just validates) and makes it easier to add the remaining stored procedure statements. - 1346: Altered the transaction interface to occur on the Session instead of on a Database
This work is preparatory to supporting multiple databases in a single transaction.
Also rewrites much of test engine test setup.
vitess
- 210: Grammar updates for replication statements
Adds support for:CHANGE REPLICATION SOURCE TO
START REPLICA
STOP REPLICA
SHOW REPLICA STATUS
- 208: Allow charsets/collations in single or double quotes for
create database
/alter database
Fixes: #4977
Closed Issues
- 5050: In
dolt config
, make--set
an alias/substitute for--add
to matchgit
's behavior - 5043:
select active_branch()
panics when using revision dbs - 4954:
dolt dump
should batch inserts - 3717: Support describe for information_schema tables
- 1503:
panic: interface conversion: interface {} is nil, not string
group by collation - 247: Memory table should error on
UPDATE
when it generates duplicate keys - 1200: Testify getting included in binary builds.
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.03 | 2.86 | 1.4 |
groupby_scan | 12.75 | 17.95 | 1.4 |
index_join | 1.25 | 5.0 | 4.0 |
index_join_scan | 1.21 | 4.25 | 3.5 |
index_scan | 31.94 | 59.99 | 1.9 |
oltp_point_select | 0.16 | 0.53 | 3.3 |
oltp_read_only | 3.13 | 9.22 | 2.9 |
select_random_points | 0.31 | 0.83 | 2.7 |
select_random_ranges | 0.37 | 1.21 | 3.3 |
table_scan | 31.94 | 65.65 | 2.1 |
types_table_scan | 73.13 | 200.47 | 2.7 |
reads_mean_multiplier | 2.7 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 3.3 | 11.45 | 3.5 |
oltp_insert | 1.58 | 2.97 | 1.9 |
oltp_read_write | 5.67 | 18.28 | 3.2 |
oltp_update_index | 1.64 | 5.28 | 3.2 |
oltp_update_non_index | 1.58 | 5.67 | 3.6 |
oltp_write_only | 2.39 | 9.06 | 3.8 |
types_delete_insert | 3.49 | 12.52 | 3.6 |
writes_mean_multiplier | 3.0 |
Overall Mean Multiple | 2.8 |
---|