Merged PRs

dolt

• 10035: Set BATS_TEST_RETRIES to be higher for flaky docker-entrypoint.bats build tests Add $BATS_TEST_RETRIES to latest and specific version build bats tests for page Not Found error that sometimes happens from GitHub API call.
• 10033: [#10015]: Support read_only to always be true in standby mode Fixes [#10015] Dolt exposes the current server's current cluster role in @@GLOBAL.dolt_cluster_role, which will be either the string standby or the string primary. MySQL has a standard system variable to expose read-only status of the server, namely read_only.
• Support read_only to always be set to true in standby mode.
• When using ClusterController, read_only setting is indirectly delegated to standby callback.
• 10026: Fixed anyMatch operator There was a bug during matching where we did not consider the children of a node when we encountered the anyMatch operator. Interestingly, this was never found as we never mixed the singular operator (%) with a diverging match ('%wy) in a test scenario, so the column marker (separates each column) was always in the sort order slice instead of being a child.
• 10025: Pass val.TupleDesc as pointer
• 10024: go/store/nbs: planRangeCopyConjoin: Account for quota when building the merged index. In contexts where memory usage is quota'd and allocation is failable, ConjoinAll should take quota when building up O(n) data structures like the merged prefix index. This change reworks planRangeCopyConjoin so that large in-memory structures are allocated through or accounted in the memory quota provider. This change should not have an impact on Dolt's current behavior, since Dolt currently always run stoage with a non-failable memory quota provider.
• 10004: [#9887]: Add mariadb-binlog test and BinlogConsumer implementation Fixes [#9887] Companion dolthub/go-mysql-server#3279 dolthub/vitess#439 dolthub/docs#2710 Add support for BINLOG 'base64data' statement, which replays binary log events. Tools like mysqldump and mariadb-binlog use it to output database changes as base64-encoded events that can be replayed on another server. bash mariadb-binlog mariadb-bin.000001 mariadb-bin.000002 | mariadb -u root -p -h 127.0.0.1 --skip-ssl

  ⚠️ Note: BINLOG statement support requires a BinlogConsumer implementation. go-mysql-server provides the interface and execution framework, but does not include a default implementation. This feature only works with Dolt or other integrators that implement the BinlogConsumer interface. ⚠️ Note: Concurrent BINLOG statements can corrupt each others states; only execute through one connection/client.

• Add BinlogConsumer interface implementation so go-mysql-server BINLOG statement can feed dolt's binlog replica applier events sequentially.
• Add tests for Binlog related queries with complementary handler that sets the engine to able to execute the queries with dolt.
• Add binlog-maker.bats to generate Binlog statement only test files in binlogreplication/testdata using mariadb-binlog which later are run using new test handler.
• Modified mysql-client-tests to include mariadb-binlog.bats which generates *.bin files with a mariadb server first to then pipe them into a dolt sql-server using a mariadb client.
• Moved session handling when processing events to caller to prevent session wrap when calling from Binlog statements.

go-mysql-server

• 3279: [#9887]: Add BINLOG and mariadb-binlog support Fixes [#9887]
• Add BinlogConsumer and BinlogConsumerCatalog interfaces.
• Add BINLOG statement that decodes base64 encoded event strings and runs them on dolt's binlog replica applier using BinlogConsumer interface.
• Add support for mariadb-binlog utility with new format support for sql_mode, collation_database, collation_connection, and collation_server, which can use bitmasks and IDs tied to system variable values.
• Add new format int support for lc_time_names; this remains a no-op.
• Add authentication handler for Binlog statement and new privilege types binlog_admin, replication_applier.
• Other system variables have been added as no-ops for mariadb-binlog compatibility: skip_parallel_replication, gtid_domain_id, gtid_seq_no, check_constraint_checks, sql_if_exists, system_versioning_insert_history, and insert_id.
• Add separate MariaDB-specific system variables array and a new getter that pulls from both system variable arrays.
• 3248: Implement sql.ValueRow sql.ValueRow is the reincarnation of sql.Row2. This is an optimization to the sqlengine that eliminates interface boxing by never placing variables into a []interface. sql.ValueRowIter is implemented by:
• TransactionCommittingIter
• TrackedRowIter
• TableRowIter
• FilterIter Comparison should only use CompareValue when left and right are both NumericType, so Integers, Floats, Decimal, Bit64, and Year types.

vitess

• 442: Additional tests for SSL requirements on created users
• 441: [#9316]: Add CREATE TABLE ... AS SELECT support Fixes [#9316] Companion dolthub/go-mysql-server#3283
• 439: [#9887]: Fix empty executable comments and add BINLOG support and mariadb executable comments Fixes [#9887]
• Add TypeName() to binlogEvent objects for error message creation on the frontend, i.e. go-mysql-server.
• Add ERBase64DecodeError = 1575, ERNoFormatDescriptionEventBeforeBinlogStatement = 1609, and EROnlyFDAndRBREventsAllowedInBinlogStatement = 1730 for Binlog statements error handling.
• Add Binlog statement parser support.
• Add mariadb executable comment support and fix handling of empty comments, i.e. /*!*/ and /*M!*/.

Closed Issues

• 10012: How to Properly Identify Read/Write and Read-Only Nodes in Dolt Cluster for ProxySQL Setup
• 10015: Feature: cluster replication: When the server is in standby mode, the read_only system variable should always be true.
• 9887: Support MariaDB mariadb-binlog which translates a MariaDB binlog to SQL queries