Nick Tobey

Put a breakpoint in `lookupJoinSelectivity` before the call to `sql.NewLookupFDs` Run the following SQL: ``` CREATE table xy (x int primary key, y int); CREATE table uv (u int primary...

Add `LazyJSONDocument`, which wraps a JSON string and only deserializes it if needed.

1

This is the GMS side of https://github.com/dolthub/dolt/issues/7749 This is a new `JSONWrapper` implementation. It isn't used by the GMS in-memory storage, but it will be used in Dolt to speed...

Avoid escaping HTML characters when displaying them to the user.

2

This fixes an issue where if a JSON document in the storage layer contains escaped characters, those escape sequences could end up being displayed to the user via the `dolt...

Allow importing CSVs without column names.

2

Both MySQL and SQLite have an option when importing data to skip the first N rows of the source file: MySQL: `LOAD DATA INFILE ... IGNORE 1 ROWS` SQLite: `.import...

Potentially related to https://github.com/dolthub/dolt/issues/7762 Steps to reproduce: Add the following test to `SchemaChangeTestsBasicCases` in `dolt_queries_schema_merge.go` ``` { Name: "ambiguous choice of ancestor column", AncSetUpScript: []string{ "CREATE table t (pk int...

"SELECT * FROM tbl" has incorrect schema when table has default values.

1

Dolt often makes a query of the form "SELECT * from tbl" and examines the resulting schema in order to get a table schema. However, depending on specific factors, this...

`AUTO INCREMENT` is supposed to be unaffected by transactions: not-yet-committed transactions can still advance the counter, and rolling back a transaction does not reset the counter. This allows two concurrent...

Incorrect return typefor UNIX_TIMESTAMP

3

According to the MySQL docs: ``` The return value [of UNIX_TIMESTAMP] is an integer if no argument is given or the argument does not include a fractional seconds part, or...

[no-release-info] Add additional tests for manipulating large JSON documents and fix corner case bugs in JSON_LOOKUP and JSON_INSERT

2

This PR adds additional tests for calling JSON_INSERT on large JSON documents. It also fixes three issues with IndexedJsonDocuments: 1) Some operations are not supported by the new optimized implementation...

A "subroutine" refers to any statement or block of statements that is defined but may not be immediately executed. MySQL has six types of subroutines: - `CREATE PROCEDURE` - `CREATE...