Merged PRs

dolt

• 4122: Burlier tests for multi-db replication
• 4121: Update README to reflect socket interface release
  Socket interface supported but not on by default.
• 4113: fix broken DOLT_DEV engine tests
• 4112: Use multiple node stores in orderedTree diff
• 4110: sql-server host shouldn't affect default superuser
  fix for: #4079
• 4100: Adding a skipped bats test for dolt_reset being disallowed in read-only mode
  We had a skipped BATS test for dolt_commit being disallowed, but dolt_reset also needs one since it modifies the branch HEAD.
• 4091: Lock new databases where source db is locked
• 4071: global auto increment tracking

go-mysql-server

• 1198: adding implicit type conversion to in <subquery> statements
  fix for: #4057
• 1197: Indexed joins range scans ignore non-equalities
  When building index lookups, do not about when we see non-equality expressions. Instead, continue with the equality subset.
  Ex:

  SELECT pk,i,f FROM one_pk RIGHT JOIN niltable ON pk=i and pk > 0
  -	RightJoin((one_pk.pk = niltable.i) AND (one_pk.pk > 0))
  -	 	├─ Table(one_pk)
  -		 │   └─ columns: [pk]
  -		 └─ Table(niltable)
  -		     └─ columns: [i f]
  +	Project(one_pk.pk, niltable.i, niltable.f)
  +	     └─ RightIndexedJoin((one_pk.pk = niltable.i) AND (one_pk.pk > 0))
  +		     ├─ Table(niltable)
  +		     │   └─ columns: [i f]
  +		     └─ IndexedTableAccess(one_pk)
  +		         ├─ index: [one_pk.pk]
  +		        └─ columns: [pk]

• 1195: SkipResultsCheck logic for TestScriptPrepared
• 1193: Fixed typos in engine tests (skipped tests not actually getting skipped)
• 1190: add support for BIT_AND, BIT_OR, and BIT_XOR functions
  fix for: #4098
• 1189: Fixed Privilege-Related Issues
  Fixes the following issues:
  • #4081
  • #4082
  • #4085
• 1188: Bug fix for recursive view definitions causing stack overflow during analysis
• 1182: Use literal for Enum/set default
  Currently enum / set default value will be evaluated(converted to int) and store in information_schema, think better to leave as their literals.
  PS: I'm also investigating if this issue related to #1131
• 1179: Preserve original enum value case on retrieval
  When retrieving enum values for ShowCreateTable,Information_Schema.Columns, and Describe/ShowColumns, they were always being converted to lowercase, which doesn't match MySQL's behavior. Instead, we should preserve the case each enum value was defined with, whenever we return those values.
  This did not affect enum values returned as part of table data – these values were already correctly preserving the originally defined case.
  Fixes: #3991
  Fixes: dolthub/go-mysql-server#1161
• 1174: sql/analyzer: Update Index Selection heuristics to prioritize Primary Key indexes
  In Dolt, this increases out TPC-C throughput by 2x for the new NBF.
• 1142: adding json_table function
  Adds some support for json_table function, which generates a table given a JSON string and column definitions.
  Fix for: #2163
  TODO:
  • NESTED
  • FOR ORDINALITY
  • ON EMPTY
  • ON ERROR

vitess

• 185: add support for grant all privileges to <user>
• 173: parse json_table syntax
  TODO:
  • NESTED
  • FOR ORDINALITY
  • ON EMPTY
  • ON ERROR

Closed Issues

• 4083: No server.lock file created for databases created after server start
• 4034: enum values should honor collation
• 2162: Length of CHAR and VARCHAR types appears to pertain to physical representation
• 2161: Support case-insensitive collation utf8mb4_general_ci
• 4081: After the mysql database is populated, it should show up in SHOW DATABASES if you have permission to see it
• 4082: Bad error message on malformed delete user
• 4085: Nil pointer dereference for create user 'foo'@'%' identified by ''
• 2391: Case of enum literals lost in information schema
• 3991: Add support for case-sensitive text in ENUM options
• 1161: ENUM values are always lowercased regardless of actual case