Maximilian Hoffman
Maximilian Hoffman
MySQL docs here: https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html Ran into this trying to import an employees database here: https://github.com/datacharmer/test_db
A default `dolt sql-server` includes the following warning statement on startup: ``` WARN[0000] secure_file_priv is set to "", which is insecure. WARN[0000] Any user with GRANT FILE privileges will be...
The subquery below has an inner EXISTS that can be decorrelated into a join, but the resulting filter references a column from an outer subquery expression: ```sql select x from...
## Some low hanging fruit Slow creating new NOW function: https://github.com/dolthub/go-mysql-server/blob/6744a0d54c8f4611177f5de0a64d29603139ef7f/sql/expression/function/time.go#L845 Slow executing NOW function (specifically `time.ConvertTimeZone`) Comparison Eval could be faster: The sorts in these queries are unnecessary: ```sql...
repro: ```sql CREATE TABLE xy (x bigint primary key, y JSON); INSERT INTO xy VALUES (0, CAST('{"a": [{"b": 1}, {"c": 2}]}' AS JSON)); select json_value(y, '$.a.b') from xy; +------------------------+ |...
The mysql syntax for `json_value` is: ``` JSON_VALUE(json_doc, path [RETURNING type] [on_empty] [on_error]) on_empty: {NULL | ERROR | DEFAULT value} ON EMPTY on_error: {NULL | ERROR | DEFAULT value} ON...
todo: drop chunk and stats version field
Setup an outline for how top-down hinting can help type coerce expressions that otherwise lack the context to know what types they need to be. The benefits of this compared...
We expose `Handler.ComMultiQuery` but no `Engine.MultiQuery` currently. In Dolt we use a scanner to parse semi-colon separated query strings into individually executable statements.