Skip to content

1.43.3

Compare
Choose a tag to compare
@github-actions github-actions released this 10 Oct 21:40

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.

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