go-mysql-server
go-mysql-server copied to clipboard
dolthub
A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
Currently "plan is not resolved because of CreateTable". Should fail with an error message similar to MySQL.
MySQL tables can have generated columns (see https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html). When trying to use this feature the statement fails with an error like `[2021-09-22 15:23:19] [HY000][1105] syntax error at position 6229 near...
ORDER BY expressions containing aggregation functions are not handled appropriately by the analyzer.
The following works because the SUM gets mapped directly to the projected SUM expression (by resolve_columns): ```sql SELECT category, SUM(price) FROM products GROUP BY category ORDER BY SUM(price) ASC ```...
Unable to filter `show databases`, and fake filters seem to not be applied ``` (base) $ dolt sql -q "show databases where nothing = 'something' " +--------------------+ | Database |...
We should only have DuplicateEntry as defined in MySQL
Currently this works, but is not supported in MySQL.
Repro: ```sql CREATE TABLE test (pk BIGINT PRIMARY KEY, v1 INT UNSIGNED); INSERT INTO test VALUES (1, "04394"); ``` Running the above query returns the following error in the integrator...
I have a table where I want to index on not just a column, but an expression, e.g. `JSON_EXTRACT(payload, '$.id')`. The docs for sql.Index say this is allowed ``` //...
