Merged PRs

dolt

• 5112: Log table count
  GMS side: dolthub/go-mysql-server#1523
• 5111: go/libraries/doltcore/sqle: database_provider.go: Reuse ReadReplicaDatabase's upstream DoltDB instance in is{Branch,Tag} instead of creating a new one.
  Calling remote.GetRemoteDB() creates a new gRPC connection pool, a new HTTP connection pool, a new chunk cache for the returned DoltDB, etc. There should only be one instance of the upstream DoltDB for the ReadReplicaDatabase, and we can just use the one we have to check for branch and tag existence.
• 5109: InSubquery bump
• 5104: Change current README edit to be more out of band
  I was not a fan of the wording of the previous edit but thought the intent was good.
• 5088: add error message for dolt commit failures
  adds additional error message when the dolt commit editor fails to open
  fixes: #5060
• 5077: Bump github.com/aws/aws-sdk-go from 1.32.6 to 1.33.0 in /go
  Bumps github.com/aws/aws-sdk-go from 1.32.6 to 1.33.0.
  Changelog

  Sourced from github.com/aws/aws-sdk-go's changelog.

  Release v1.33.0 (2020-07-01)

  Service Client Updates

  • service/appsync: Updates service API and documentation
  • service/chime: Updates service API and documentation
    • This release supports third party emergency call routing configuration for Amazon Chime Voice Connectors.
  • service/codebuild: Updates service API and documentation
    • Support build status config in project source
  • service/imagebuilder: Updates service API and documentation
  • service/rds: Updates service API
    • This release adds the exceptions KMSKeyNotAccessibleFault and InvalidDBClusterStateFault to the Amazon RDS ModifyDBInstance API.
  • service/securityhub: Updates service API and documentation

  SDK Features

  • service/s3/s3crypto: Introduces EncryptionClientV2 and DecryptionClientV2 encryption and decryption clients which support a new key wrapping algorithm kms+context. (#3403)
    • DecryptionClientV2 maintains the ability to decrypt objects encrypted using the EncryptionClient.
    • Please see s3crypto documentation for migration details.

  Release v1.32.13 (2020-06-30)

  Service Client Updates

  • service/codeguru-reviewer: Updates service API and documentation
  • service/comprehendmedical: Updates service API
  • service/ec2: Updates service API and documentation
    • Added support for tag-on-create for CreateVpc, CreateEgressOnlyInternetGateway, CreateSecurityGroup, CreateSubnet, CreateNetworkInterface, CreateNetworkAcl, CreateDhcpOptions and CreateInternetGateway. You can now specify tags when creating any of these resources. For more information about tagging, see AWS Tagging Strategies.
  • service/ecr: Updates service API and documentation
    • Add a new parameter (ImageDigest) and a new exception (ImageDigestDoesNotMatchException) to PutImage API to support pushing image by digest.
  • service/rds: Updates service documentation
    • Documentation updates for rds

  Release v1.32.12 (2020-06-29)

  Service Client Updates

  • service/autoscaling: Updates service documentation and examples
    • Documentation updates for Amazon EC2 Auto Scaling.
  • service/codeguruprofiler: Updates service API, documentation, and paginators
  • service/codestar-connections: Updates service API, documentation, and paginators
  • service/ec2: Updates service API, documentation, and paginators
    • Virtual Private Cloud (VPC) customers can now create and manage their own Prefix Lists to simplify VPC configurations.

  Release v1.32.11 (2020-06-26)

  Service Client Updates

  • service/cloudformation: Updates service API and documentation
    • ListStackInstances and DescribeStackInstance now return a new StackInstanceStatus object that contains DetailedStatus values: a disambiguation of the more generic Status value. ListStackInstances output can now be filtered on DetailedStatus using the new Filters parameter.
  • service/cognito-idp: Updates service API

  ... (truncated)

  Commits

  • b5d0d96 Release v1.33.0 (2020-07-01)
  • 4705b39 Fix CHANGELOG_PENDING.md entry (#3404)
  • dda576e service/cloudfront/sign: Fix Documentation Typo (#3402)
  • 35fa6dd service/s3/s3crypto: V2 Client Release (#3403)
  • 9dbc703 Release v1.32.13 (2020-06-30) (#3400)
  • 6ec1b39 Release v1.32.12 (2020-06-29) (#3397)
  • 15f0e61 Release v1.32.11 (2020-06-26) (#3395)
  • cd54c31 Release v1.32.10 (2020-06-25) (#3393)
  • 8932aba Release v1.32.9 (2020-06-24) (#3391)
  • ea6bf35 Release v1.32.8 (2020-06-23) (#3388)
  • Additional commits viewable in compare view
  
  [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually 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 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) - `@dependabot use these labels` will set the current labels as the default for future PRs for this repo and language - `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language - `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language - `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dolthub/dolt/network/alerts).

go-mysql-server

• 1523: Change coster for non-stats tables
  dolt side #5112
• 1517: Added the remaining statements for stored procedures
  Also added labels to BEGIN...END blocks, which were missing.
• 1511: Fix nested subquery expression caching regression
• 1510: verify and fix info schema tables - 2
  • Complete tables:
    CHARACTER_SETS
COLLATIONS
ENGINES - only the InnoDB engine is supported
    SCHEMATA
COLLATION_CHARACTER_SET_APPLICABILITY
  • Some info missing:
    COLUMN_STATISTICS - histogram json column only has buckets key values.
    PROCESSLIST - status is not defined completely; "Query" command is supported only.
• 1509: Remove IndexedInSubqueryFilter, add SemiLookupJoin, AntiJoin
  • IN_SUBQUERY and EQUALS_SUBQUERY (and NOT ...) are converted to joins when the subquery does not reference the outer scope
  • RIGHT_SEMI_JOIN and RIGHT_SEMI_LOOKUP_JOIN are added as a replacement for IndexedInSubqueryFilter
  • MAX_1_ROW added for runtime-enforcement, previously handled by EvalMultiple
  • fix various bugs in join iter and lookup generation
    Note:
  • RIGHT_SEMI_LOOKUP_JOIN is only safe when the left side of the join is converted into a unique index lookup, otherwise duplicate rows will have been missed
    TODO:
  • selection, projection, etc rearrangements moving towards JoinApply for correlated expressions
  • collapse scopes without losing MAX_1_ROW enforcement
  • deduplicate tables in joins without losing MAX_1_ROW and row duplication constraints

vitess

• 213: Added additional CASE form
  Forgot that there are two forms to CASE statements, so I added the missing version.
• 212: add GRANT OPTION for GRANT STATEMENTS
• 211: Added last statements for stored procedures
  Of note, RETURN is used by stored functions and not stored procedures, but I added it anyway since it was super simple and we'll need it at some point.
• 210: Grammar updates for replication statements
  Adds support for:
  • CHANGE REPLICATION SOURCE TO
  • START REPLICA
  • STOP REPLICA
  • SHOW REPLICA STATUS

Closed Issues

• 5106: Integrate pull request preview environments
• 5060: Bad config error when trying to merge
• 5102: Can't drop not null constraint from this schema with unique keys

Latency