Merged PRs
dolt
- 7963: Create pg_catalog by default for Doltgres
This makes it such thatpg_catalog
is created by default when Doltgres is using Dolt. In addition, adds a new function to hook into schema functionality.
go-mysql-server
- 2552: support
VALUES
statement
fixes #8012
syntax: dolthub/vitess#354 - 2551: unwrap parenthesized table references
fixes #8009
vitess
- 354: support
VALUES
statement
This PR add syntax support forVALUES
statment as an alias forSELECT * FROM ...
.
We are still missingSELECT (VALUES ...)
(support for values as aselect_expression
).
syntax for #8012 - 353: allow backticks in system and user variables
This PR allows the use of backticks in system and user variables.
We are more lenient than MySQL when it comes to backticks in set statements.
For example, we allowset @abc.
def= 10
, while MySQL throws an error.
This is because we treat this as a qualified column identifer and automatically strip the backticks.
test bump dolthub/go-mysql-server#2548
fixes #8010
Closed Issues
- 8012: VALUES statement not supported
Performance
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.07 | 2.81 | 1.4 |
groupby_scan | 13.46 | 17.32 | 1.3 |
index_join | 1.37 | 5.37 | 3.9 |
index_join_scan | 1.27 | 10.84 | 8.5 |
index_scan | 34.95 | 53.85 | 1.5 |
oltp_point_select | 0.18 | 0.46 | 2.6 |
oltp_read_only | 3.49 | 7.56 | 2.2 |
select_random_points | 0.34 | 0.75 | 2.2 |
select_random_ranges | 0.39 | 0.9 | 2.3 |
table_scan | 34.95 | 54.83 | 1.6 |
types_table_scan | 75.82 | 137.35 | 1.8 |
reads_mean_multiplier | 2.7 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
oltp_delete_insert | 7.98 | 6.09 | 0.8 |
oltp_insert | 3.82 | 3.02 | 0.8 |
oltp_read_write | 8.58 | 13.95 | 1.6 |
oltp_update_index | 3.89 | 3.07 | 0.8 |
oltp_update_non_index | 3.89 | 3.02 | 0.8 |
oltp_write_only | 5.37 | 6.32 | 1.2 |
types_delete_insert | 7.7 | 6.67 | 0.9 |
writes_mean_multiplier | 1.0 |
TPC-C TPS Tests | MySQL | Dolt | Multiple |
---|---|---|---|
tpcc-scale-factor-1 | 99.66 | 26.16 | 3.8 |
tpcc_tps_multiplier | 3.8 |
Overall Mean Multiple | 2.50 |
---|