Merged PRs

dolt

• 7158: /{go,integration-tests}: add oci blobstore implementation
  This PR adds an Oracle Cloud Infrastructure (OCI) blobstore implementation.
  OCIBlobstore.Concatenate is unimplemented as OCI doesn't currently support building composite objects.
  OCIBlobstore.Put will use the objectstorage.PutObject method for uploads smaller than the minimum multipart upload part size of 10MB, but will use the Multipart Upload process for all uploads larger than 10MB.
  Objects have a VersionId as well as an ETag, however the ETag value is used for the conditional match header, not the VersionId, see https://github.com/oracle/oci-go-sdk/blob/v65.54.0/objectstorage/get_object_request_response.go?s=719:5196#L39
  UPDATE: this PR also contains changes so that an Oracle bucket can be used as a remote and backup

go-mysql-server

• 2217: Fix decimal parsing bug
  Decimals with capitalized exponential 'E' were incorrectly bound to literals, losing precision in some cases.

  select 5.0E-5; // -> 0.0001

• 2210: sql/planbuilder: Update join defaults are not prefixed, need individual table schemas to resolve
  Updates need to resolve default expressions. The input definitions for update joins include the total join output columns. If two of those columns have the same name, the target table's unqualified default expression will throw an "ambiguous column" error. We partition the update join schemas/column definitions to sidestep the error.
  The case where this is problematic is ALTER COLUMN expressions, where only the columns being modified are scoped for some reason. In those cases, I create a new scope with the source table schema to provide the full set of underlying column definitions. There is probably a whole class of virtual columns/column default bugs related to the way we resolve alter statements.
• 2208: fix type evaluating for mult and div arithmetic operations
  • For Mult expression, the .Type() method is fixed that it returns correct type for decimal type results, which uses the sum of precision and scale values of its right and left values.
  • For Div expression, the .Type() method is fixed that it returns the correct precision and scale for the final result.
• 2204: fix foreign key panic on update
  When resolving ForeignKeys, ForeignKeyReferenceHandler.CheckTable() calls Partition() and iterates over all rows in the referenced table to ensure that the key is valid (doesn't contain any values that are not in the referenced table).
  WriteableIndexedDoltTable prevents us from reading every value through Partition() as it is only supposed to return rows that match the index range. Additionally, there are some differences between the way MySQL and dolt handle certain ddl and dml operations during delayed resolution of Foreign Keys.
  To fix this, we selectively perform table scans (only when we are creating/altering the table to resolve foreign keys).
  Fixes #6963
  Companion PR: #7203

Closed Issues

• 6963: Update FK panic

Latency