Merged PRs

dolt

• 4872: Changing loglevel param to be case insensitive.
  This allows the loglevel CLI param and log_level YAML config key to be case insensitive.
  Fixes: #4864
• 4871: fixes for dolt Docker images and ORM integration tests
  • Added WORKDIR for client Dockerfile
  • Fix path issue in dolt server docker entrypoint
  • Fix ORM integration tests
• 4858: add ORM integration tests job to github nightly jobs
  If the ORM tests fail, the github email notification will likely to go to the github actor of the scheduled job.
  It can be set to fixed emails through dawidd6/action-send-mail@v2 action
• 4851: use tini init system in docker container
  It's helpful for avoiding zombie processes and provides signal handling such as SIGTERM from docker stop
• 4849: Get the version v1.1.2 of github.com/HdrHistogram/hdrhistogram-go
  Updating to the latest version of github.com/HdrHistogram/hdrhistogram-go removes a lot of extraneous packages that were pulled in with v1.0.0, such as the linter github.com/golangci/golangci-lint
  This resolves #4836
• 4848: go/doltcore/dbfactory: enforce singleton creation of datas.Database
• 4847: pick new viable underlying index for foreign keys when current one is dropped
  When dropping underlying secondary indexes used by foreign key, another existing viable one should be used in its place, unless there isn't one.
  TODO:
  • we should show duplicate indexes to primary key because MySQL does
• 4845: history system table missing projections
  history table was returning size-0 rows to the filter in the test case; the filter was erroring for the out of bounds index
• 4832: Online shallow gc
  Adds a dolt_gc procedure that runs shallow online garbage collection (prunes unused table files). A more complete online garbage collection is coming soon

go-mysql-server

• 1426: Have JSONDocument implement driver.Valuer
• 1424: Refactor check for canonical join
• 1422: add uptime
  not quite sure how to test or if it's the best way to have system variables that dynamically update...
  fix for: #4473
• 1420: Fix issue where case expression is evaluated too early
  Fix issue where case expression is evaluated and the result is being treated as a literal.
  Fixes #4716
• 1417: Fixed integer handling when given a floating number
  Integers are supposed to round floating numbers, but we just did a simple conversion so we were truncating the decimal portion.
• 1412: prevent modifying columns to blob/text without prefix length in index
  There's an edge case in where there's an index defined over a column without a prefix length, and if you modify that colunm to a text/blob it should throw an error. Additionally, it should preserve prefix lengths when it's still a string type. If the new type is too short, the prefix length should be dropped.
• 1411: Fix for commutative join types getting stuck in analysis loop
  This change fixes an issue where the analyzer can get stuck in a loop bouncing back and forth between the original and commuted plan and being unable to stabilize the plan.
  As part of that fix... it also deduplicates logically identical relExprs in exprGroups and changes the finalizeSubqueries analyzer rule so that it only runs once on each subquery, from the bottom of the plan tree, up.
  Fixes: #4816
  Dolt Tests: #4859

vitess

• 202: support explaining tables, and adding extended keyword
  Even though it is deprecated, we can support EXPLAIN EXTENDED, since it does the same thing as normal EXPLAIN
  https://dev.mysql.com/doc/refman/5.7/en/explain.html#:~:text=In%20older%20MySQL%20releases%2C%20extended%20information%20was%20produced%20using%20EXPLAIN%20EXTENDED.
  Additionally, EXPLAIN, DESCRIBE, and DESC are all interchangable, so we should be able to EXPLAIN tbl
  Fix for: #4185
• 200: Support calling procedures from specified database.

  Description

  Support calling procedures from specified database, for example call mydb.test();

  Related Issue(s)

  This fixes #4725

  Checklist

  • "Backport me!" label has been added if this change should be backported
  • Tests were added or are not required
  • Documentation was added or is not required

  Deployment Notes

  No deployment notes, this adds missing SQL support.

Closed Issues

• 4866: docker-entrypoint.sh—get_config_file_path_if_exists—.$CONFIG_DIR makes path relative
• 4867: Client Dockerfile—does not know new WORKDIR pattern
• 4864: Incorrect capitalization of sql-server param in docs
• 4816: Analyzer error: exceeded max analysis iterations (8)
• 4840: [Feature Request]: Support PostgreSQL
• 4500: Describe for default value expressions is formatted incorrectly
• 4185: Support EXPLAIN EXTENDED
• 4174: Recursive CTE fails when executed using JDBC driver
• 4716: Simple case statement doesn't work with enums
• 4843: When sql server is started in docker, any subsequent dolt cli call leave defunct processes
• 4836: Dolt CLI has an unnecessary dependency on golangci-lint