Merged PRs

dolt

• 4846: Schemas with different PK ordinals should not be equal.
  Fixes #4844
• 4831: Fix issues with docker entrypoint
  1. Fix unability to process .sql in initdb
     If user has some .sql files in /docker-entrypoint-initdb.d they will have an error:

  2022-11-21 11:02:13+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/init.sql
  /usr/local/bin/docker-entrypoint.sh: line 98: docker_process_sql: command not found
  

  This PR fixes it
• 4829: add Hibernate smoke test
• 4825: Blob chunker rewrite
  Rewrite blob chunking to use a a fixed amount of memory.
  
  (name) (iterations) (nanoseconds/iteration) (bytes/iteration) (allocations/iteration)

  -- after
  BenchmarkBlobBuilder/datasize:_3
  BenchmarkBlobBuilder/datasize:_3-12         	  234128	      5673 ns/op	    2608 B/op	       8 allocs/op
  BenchmarkBlobBuilder/datasize:_4
  BenchmarkBlobBuilder/datasize:_4-12         	   26074	     41468 ns/op	   17560 B/op	      24 allocs/op
  BenchmarkBlobBuilder/datasize:_5
  BenchmarkBlobBuilder/datasize:_5-12         	    2737	    378950 ns/op	  133004 B/op	     134 allocs/op
  BenchmarkBlobBuilder/datasize:_6
  BenchmarkBlobBuilder/datasize:_6-12         	     282	   3974650 ns/op	 1288281 B/op	    1269 allocs/op
  -- before
  BenchmarkBlobBuilder
  BenchmarkBlobBuilder/datasize:_3
  BenchmarkBlobBuilder/datasize:_3-12         	   15231	     75445 ns/op	  460464 B/op	      17 allocs/op
  BenchmarkBlobBuilder/datasize:_4
  BenchmarkBlobBuilder/datasize:_4-12         	    6844	    171266 ns/op	  923121 B/op	      50 allocs/op
  BenchmarkBlobBuilder/datasize:_5
  BenchmarkBlobBuilder/datasize:_5-12         	    1875	    549793 ns/op	 1040770 B/op	     270 allocs/op
  BenchmarkBlobBuilder/datasize:_6
  BenchmarkBlobBuilder/datasize:_6-12         	     273	   4389403 ns/op	 2668899 B/op	    2543 allocs/op
  

• 4812: use prefix index for referenced strings
  fixes error message for unique key violation to print prefix instead of string ref
  for indexes over referenced strings, we always just store the prefix of the string/byte inline
• 4768: change dolt docs doc_text column to longtext
  Fix for: #4713

go-mysql-server

• 1419: errors to date_add() and date_sub() are warnings
  fixes part of: #4643
  Will implement TIME() and sql.Time type in a separate PR.
• 1416: add histogram column to information_schema.column_statistics
  fix for: #4412
• 1415: support show status
  Fix for: #4473
  The way I get and display the variables in the right scope is a little inefficient, but not enough to really matter.
  TODO:
  • Need a good way to test these queries.
  • we are missing a ton of variables, worth adding?
• 1414: limit arithmetic literals are all ints but different types
  for query with ... limit 0, 200 in TopN plan, arithmetic was returning decimal type because 200 was handled asuint8 and 0 was int8 types, so if the both the values are any non-matching int type, the values are converted to int64 for + and - operations.
• 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.
• 1399: Add tests to verify that we call call qualified procs.
  Adding tests for #4725
  go.mod is pointing to this PR's branch: dolthub/vitess#200

vitess

• 201: adding parser support for prepared, execute, and deallocate
  supporting syntax for: #4452
• 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

• 4844: [dolt migrate] Fails validation when the primary keys are re-ordered
• 4238: Two dot dolt log
• 4511: Prisma tool compatibility
• 4737: migrate: byte slice is not of expected size
• 4840: [futuries requiest]: support PostgreSQL
• 4790: [dolt migrate]: migration failed with conflicts
• 4687: sql log took long time, how can i make it faster?
• 4707: as of queries fail in StarRocks
• 4713: Dolt docs doc_text column is varchar(16383), should be TEXT
• 4412: mysqldump of JSON type columns require a HISTOGRAM column in information_schema.COLUMN_STATISTICS which Dolt does not provide
• 4725: Calling a stored procedure with DB name in the query is not supported

Latency