github dolthub/dolt v1.43.3
1.43.3

11 hours ago

Merged PRs

dolt

  • 8434: Fix GetSchema for detached head
  • 8430: Database returns tables in all schemas when schema is not set
  • 8425: testing benchmarks

go-mysql-server

  • 2689: Support for schema name in SHOW TABLE statements
    This provides support for show tables from public and show table from mydb.public in postgres dialects.
  • 2685: unbump protobuf
  • 2676: Optimization: Defer Projections for Server Queries
    This PR speeds up spooling queries from the server to client when there is a top level projection.
    Changes include:
    • remove unnecessary double allocation of NewROw
    • defer projections until RowToSQL to avoid one extra allocation of sql.Row
      Additionally, this PR cleans up and refactors some code surrounding projections.
  • 2451: Bump google.golang.org/protobuf from 1.28.1 to 1.33.0
    Bumps google.golang.org/protobuf from 1.28.1 to 1.33.0.
    Dependabot compatibility score
    You can trigger a rebase of this PR by commenting @dependabot rebase.
    [//]: # (dependabot-automerge-start)
    [//]: # (dependabot-automerge-end)

    Dependabot commands and options
    You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dolthub/go-mysql-server/network/alerts).
    > **Note** > Automatic rebases have been disabled on this pull request as it has been open for over 30 days.

vitess

  • 370: Collapse union types
    Replace union type with one interface type. Static type access in reducer stack become runt-time interface conversions. The compiler builder loses the ability to do type checking at build time, so type safety has to be checked with testing.
    Additional type enforcements are needed for nil-safety. Nil return values have to be typed correctly in the interface variable for casts up the stack to pass. Interface types do not have default nil values, so I've added tryCastXXX helper functions to accommodate untyped nils.
  • 369: Added schema name to show table opts
    No way to populate this field from the parser directly, must be set manually when generating the AST via other means.
  • 367: Adding AST support for setting/dropping column attributes
    AST support for altering type and not null constraint, without having to respecify the full column definition. Needed to support Postgres' more modular ALTER TABLE syntax.

Closed Issues

  • 3886: Implement dolt fsck

Performance

Read Tests MySQL Dolt Multiple
covering_index_scan 2.11 0.62 0.3
groupby_scan 13.46 16.71 1.2
index_join 1.37 2.3 1.7
index_join_scan 1.27 1.89 1.5
index_scan 34.33 54.83 1.6
oltp_point_select 0.18 0.27 1.5
oltp_read_only 3.49 5.47 1.6
select_random_points 0.34 0.61 1.8
select_random_ranges 0.39 0.62 1.6
table_scan 34.95 55.82 1.6
types_table_scan 75.82 144.97 1.9
reads_mean_multiplier 1.5
Write Tests MySQL Dolt Multiple
oltp_delete_insert 8.13 5.88 0.7
oltp_insert 3.82 2.91 0.8
oltp_read_write 8.58 11.24 1.3
oltp_update_index 3.89 2.97 0.8
oltp_update_non_index 3.89 2.91 0.7
oltp_write_only 5.37 5.99 1.1
types_delete_insert 7.7 6.32 0.8
writes_mean_multiplier 0.9
TPC-C TPS Tests MySQL Dolt Multiple
tpcc-scale-factor-1 98.69 40.5 2.4
tpcc_tps_multiplier 2.4
Overall Mean Multiple 1.60

Don't miss a new dolt release

NewReleases is sending notifications on new releases.