Qnap [ Dolt Cli ] [ 0.52.3 ] Dolt is Git for Data!

0.39.5

Cliquez pour agrandir...

• 3326: Option for sysbench perf tests to clone big repo
• 3320: Add Support for new Transaction Query Plans
  This PR integrates new GMS changes to ensure that the new TransactionCommittingNode works. As a result it addresses #3240
• 3319: Add perf runner test
• 3318: Display schema and data for created and dropped tables in dolt diff command
  Fixes: #3300
  The dolt diff command was previously omitting schema and data diffs if tables were created or dropped within the commit range, and only outputting diff summary information with tabular output. This change causes the schema changes and data changes to be included in tabular output.
  Old behavior:
  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko j6n5727at9652tri8ncsa02v794h1fi4
  diff --dolt a/a b/a
  added table
  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko ccm9bfiv6jhft1tmeu1cqd0ghduhg4v7
  diff --dolt a/a b/a
  added table
  ❯ dolt diff qd507o2jjlckjgmn2polsmiifk62vo8n js1bb2cvdr7h4tdj2d3m33jhp9rc9ee9
  diff --dolt a/a b/a
  deleted table
  
  New behavior:
  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko j6n5727at9652tri8ncsa02v794h1fi4
  diff --dolt a/a b/a
  added table
  +CREATE TABLE `a` (
  + `n` int NOT NULL,
  + PRIMARY KEY (`n`)
  +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  +-----+---+
  | | n |
  +-----+---+
  +-----+---+
  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko ccm9bfiv6jhft1tmeu1cqd0ghduhg4v7
  diff --dolt a/a b/a
  added table
  +CREATE TABLE `a` (
  + `n` int NOT NULL,
  + PRIMARY KEY (`n`)
  +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  +-----+---+
  | | n |
  +-----+---+
  | + | 1 |
  | + | 2 |
  +-----+---+
  ❯ dolt diff qd507o2jjlckjgmn2polsmiifk62vo8n js1bb2cvdr7h4tdj2d3m33jhp9rc9ee9
  diff --dolt a/a b/a
  deleted table
  -CREATE TABLE `a` (
  - `n` int NOT NULL,
  - PRIMARY KEY (`n`)
  -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  +-----+---+
  | | n |
  +-----+---+
  | - | 1 |
  | - | 2 |
  | - | 3 |
  +-----+---+
  
  
• 3316: Max/fix nightly
• 3291: Use Transactional Logic to Revert Triggers
  Fix for: #2613
  Note: can't roll back in GMS / in-memory tables as they don't have any transactional logic, so we don't test there

go-mysql-server​

• 986: support XOR logic operator
  Added XOR MySQL logic operator
• 985: Fix Handler queries when Prepared Statements are Disabled
  Fix for: #3305
• 983: Change Autocommit Query Plan
  This PR adds a new analyzer rule and query Node for autocommit. This fixes an issue where previously a query process was being killed (via a cancelCtx function) before a transaction committed.
• 982: adding flag options 2 and 4 for st_asgeojson
  fix for: #3280
• 978: Use transactional logic to rollback bad triggers, also tests
  Added a new rule that wraps everything in a TriggerRollback node if there is a trigger present. This new node will make a savepoint right before execution, and will return to normal if something breaks.

vitess​

• 154: move CURRENT to non-reserved-keyword-list
  CURRENT is non reserved keyword, it fixes issue of SELECT * FROM current query failing
  Fixes #3224

Closed Issues​

• 3240: Potential Compatibility issue with Knex
• 2613: Changes, made by "before insert" trigger do not rollback when insert fails
• 3300: dolt diff doesn't show data diff when table was added within the commit range
• 3305: DISABLE_PREPARED_STATEMENTS errors
• 3309: dolt pull fails when other branch exists in the repo

Cliquez pour agrandir...

0.40.19​

Merged PRs​

dolt​

• 3860: bats tests for reading privs.json and converting
  tests for: #3859
  companion pr: dolthub/go-mysql-server#1124

go-mysql-server​

• 1124: still read JSON privilege files, but write flatbuffer format
  fix for: #3859
  tests are in dolt pr
  companion pr: #3860
• 1120: Support where clause for show variables
  Where clause is supported only for variable_name column of result table of show variables query.
  Fixes #3834
• 1117: Add foreign key tests where the parent table has inverted primary keys
• 1116: Add tests for unique key violations and fix engine to pass them
• 1111: Bug fixes for AlterPK and column defaults
  Operations that modify a table's schema were not consistently resolving column default values:
  • AlterPK was missed in resolve column default switch cases, and also wasn't considering its expressions when checking for resolution.
  • AlterDefaultSet was resolving the wrong schema (its output schema, OkResultSchema, instead of the target schema).
    While I was in there, I cleaned up the code to more consistently use the sql.TargetSchema interface and combined some copy/pasted switch cases.
    Updated existing tests to use column default values and verified they caught both of these failures. Have already run Dolt engine tests and verified they pass correctly.
    Fixes: #3788

Closed Issues​

• 3853: Calling SELECT DOLT_BRANCH('-d', '<branch-name>') results in [HY000][1105] attempted to delete a branch that is not fully merged into its parent; use -f to force
• 3815: Branch deletes (and maybe other things) don't replicate
• 3788: Panic when altering the PK on a table with column defaults
• 3834: Show Variables Where Is An Unsupported Feature

Cliquez pour agrandir...

0.40.20​

Merged PRs​

dolt​

• 3905: Fix for persisted database specific system variables failing to load
  Fix for #3887
  Persisting and loading ${branch_name}_default_branch from config now works.
• 3901: Update release and nightly files to include import benchmarking
• 3899: go/store/types: SerialMessage: Unify TupleRowStorage and SerialMessage.
  Get rid of TupleRowStorage and use SerialMessage everywhere. In turn, change
  SerialMessage so that it carries its kind and size prefix as part of itself.
• 3898: /.github/workflows/ci-performance-benchmarks-new-format.yaml: remove since #benchmark also does new format
• 3894: fix minor log.Fatalln output
  Signed-off-by: Abirdcfly fp544037857@gmail.com
  log.Fatalln is equivalent to Println() followed by a call to os.Exit(1).
  see example:
  https://go.dev/play/p/VcdbrSNK6wH
  package main
  import (
  "log"
  "os"
  )
  func main() {
  log.Fatalln("A")
  log.Fatalln("B") // unreachable code
  os.Exit(2)
  }
  /* output:
  2009/11/10 23:00:00 A
  Program exited.
  */
• 3875: Benchmark __DOLT_1__ on release
• 3868: yaml config also initialize .doltcfg directories
  Fix for: #3865
• 3867: Sql server jwt auth
  GMS PR: dolthub/go-mysql-server#1123
• 3862: Support dolt_remote() stored procedure
  Supported options:
  DOLT_REMOTE('add', ...)
  DOLT_REMOTE('remove', ...)
  DOLT_REMOTE('rm', ...)
  Got dialer out of env.Remote object definition, dialer will be set when GetRemoteDB() method is called in dolt push and pull
  Manually copied DoltDatabaseProvider interface from Zach's PR, #3745 , in order to get Zach's implementation of accessing FS from the Provider object.
• 3861: Add a better error message for schema mismatch
  With csv file imports we used to throw an error if the a read row did not have the same numbers of columns as the original schema.
  For example:
  Rows Processed: 0, Additions: 0, Modifications: 0, Had No Effect: 0
  A bad row was encountered while moving data.
  csv reader's schema expects 3 fields, but line only has 2 values.
  line: '5,5,'
  These can be ignored using '--continue'
  
  This is not particularly useful output when the size of the row is massive. It has been a headache debugging this issue for the recent museums bounty. This pr is changing the error message to as follows:
  Rows Processed: 0, Additions: 0, Modifications: 0, Had No Effect: 0
  A bad row was encountered while moving data.
  CSV reader expected 3 values, but saw 2.
  The row was interpreted to be: '{
  "pk": "5"
  "v1": "5"
  "v2": ""
  }
  '
  
  Also improve printing for skipping rows
• 3745: dolt_clone stored procedure
  Adds support for a new dolt_clone() stored procedure.
  Removes most of the use of os.Chdir (except for in test code and one or two dolt-cli-only spots).
  Doc Updates: dolthub/docs#804

go-mysql-server​

• 1129: json_contains bug fixes
  Bug fixes for Dolt's implementation of json_contains (MySQL Documentation)
  Fixes: #3895
• 1125: revert superuser to be any host
• 1124: still read JSON privilege files, but write flatbuffer format
  fix for: #3859
  tests are in dolt pr
  companion pr: #3860
• 1123: Allow plugin for other auth types
  Implementation doc: https://docs.google.com/document/d/1ts7ht9p-VkNgYhD2ouXRGNn8DdPP8wHTNm_T8voSDTE/edit?usp=sharing
  Needed vitess changes: dolthub/vitess#172
• 1118: superuser is localhost
  Companion PR: #3810

vitess​

• 172: Changes for adding new auth method
• 171: Add rows parsing for LOAD DATA IGNORE and address flaky tls test
  This PR does two things
  1. Addresses #2548 by introducing new conditions in sql.y
  2. Addresses flaky tls server tests by updating tests to use Tls13 and adding an additional error check

Closed Issues​

• 3919: Using dolt sql with a running dolt sql-server
• 3895: "Invalid argument" for json_contains() queries
• 3806: Need a way to add, modify and delete remotes on SQL path
• 3481: Panic with describe
• 3513: Implement cherry-pick
• 3623: Deprecate multi-db-dir, databases field in config.yaml
• 3865: v0.40.18 tries to open empty string as privilege file if not explicitly provided
• 3859: Reading Old Version of Privilege File with Newer version of Dolt causes Panic

Cliquez pour agrandir...

0.40.27​

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

Cliquez pour agrandir...

0.40.32​

Merged PRs​

dolt​

• 4229: go/doltcore/sqle/globalstate: Reset AUTO_INCREMENT sequence to 1 on table drop
• 4206: fix wrong error variable used

go-mysql-server​

• 1227: Fixed collation error message, added more collations
  Fixes #4236, in addition to adding two new collations:
  • utf8mb3_unicode_ci
  • utf8mb4_unicode_520_ci
• 1225: Hoist CTEs above Filter, Limit, OrderBy, and Having
• 1224: SET NAMES collation fix, results have proper charset
  Fixes two issues. SET NAMES would cause all statements that feature a COLLATE expression to error if the character set and collation did not match, however such a comparison only makes sense for string literals (at parse time). This has been fixed, as the parse-time check only occurs for literals, and checks that require analysis (such as table columns) now occur at the appropriate time. In addition, the system variable character_set_results was not used when returning string results, resulting in unexpected behavior, which has also been fixed.
• 1223: fix infinite recursion during cte self-reference
  Changes:
  • don't resolve subqueries where there are CTEs of the same name; transformations are bottom up, so they've been resolved at least once already
    Fix for:
  • #4173

Closed Issues​

• 3142: Dolt pull using 90% of memory
• 3111: Start supporting the mysql database
• 3087: unknown push error When pushing a branch with a 20,000 commits to DoltHub
• 3064: trying to drop a column used in a foreign key gives a bad error message
• 3051: CREATE TABLE with RESERVED KEYWORD status breaks
• 2820: Using --continue flag for dolt table import -u doesn't add any rows
• 2808: Support minio as remote storage
• 2756: set root password in SQL session without removing administrator password
• 2723: DOLT_CHECKOUT('-b', 'newbranch) should take working set changes to new branch
• 2673: Reorder of columns in UNIQUE INDEX when re-create table
• 2637: Dolt SQL shell can't handle semicolons in comments
• 2600: dolt diff does not show schema changes when modifying constraints
• 2594: Dropping and readding constraints generates schema diff
• 2591: dolt constraints should be exposed in the top level dolt help text
• 4173: Query crashes SQL server
• 4236: Bad collation Error Message
• 4222: Can't build dolt with LTO
• 2398: panic for dolt_diff tables when in detached head mode
• 4103: dolt ls --verbose panics in the new format
• 4123: count(*) in new format 3X slower for large table
• 2359: CLI supports param for different working directory
• 2335: Identical schema alterations results in two different columns with same tag error on merge
• 2328: dolt pull -f fails when dolt fetch -f works && dolt branch main remotes/origin/main -f works
• 2315: DOLT_MERGE should return detailed error
• 2311: Tableplus can't detect Table
• 2306: daemon mode
• 2305: confusing error message when selecting from conflict tables with @@autocommit = true
• 2304: Reverse order between from_commit and to_commit of "dolt_commit_diff_$table" will throw out exception and code stack
• 2296: Prevent branch deletion when another client has a session open on it
• 2292: [Feature Request] Progress Indicators for GC
• 2286: Dolt errors out on table definitions that use a UNIQUE KEY and KEY on the same column
• 2283: [Feature Request] Progress indicator for merges
• 2275: golang go-sql-driver/mysql does't work with Multiple HEADs
• 2260: Can't connect with Visual Studio MySQL Connector
• 2181: dolt table import -u <table> slows down almost 20x after only five imports of ~20k rows
• 2118: dolt import table Foreign Key NOT NULL violation error is not helpful
• 2070: Dolt doesn't respect primary key for sort order
• 2018: Deleting branch does not delete associated working set
• 1708: Feature request: show status during dolt sql edits
• 1561: Django multi-table inheritance: duplicate primary key error on edit
• 1318: When checking out via SQL, views don't automatically update
• 1010: Show progress on dolt schema import
• 655: Dolt SQL vs MySQL client: MySQL client right justifies number columns
• 407: Weird group by behavior
• 1096: go 1.17 support

Cliquez pour agrandir...