James Cor

Changes: - can parse valid queries like `create table test (t text, primary key (t(10)))` - throw errors that better match MySQL for blob/text indexes TODO: - `SHOW CREATE TABLE`...

Steps to reproduce: ``` tmp_db> create table mytbl (i int); tmp_db> create table seqtbl (x int); tmp_db> insert into seqtbl values (1000); Query OK, 1 row affected tmp_db> create trigger...

bad conversion between string and decimal types with trailing 0s

2

When converting between strings and decimals for `HASH IN ` expressions, trailing 0s cause a problems. There's a skipped test added in this PR: https://github.com/dolthub/go-mysql-server/pull/2267 Setup: ```sql create table t...

We handle `doubles`/`float64s` just fine by themselves ```sql tmp> select 1.7e+308; +----------+ | 1.7e+308 | +----------+ | 1.7e+308 | +----------+ 1 row in set (0.00 sec) ``` but struggle when...

Whenever a string is converted to a double, MySQL truncates the invalid portions of the string, throws a warning, and continues with rest of the operation. In dolt, we throw...

lateral join with aggregation returns wrong results Set up: ```sql CREATE TABLE c (c_id INT PRIMARY KEY, bill TEXT); CREATE TABLE o (o_id INT PRIMARY KEY, c_id INT, ship TEXT);...

Missing support for `ALL`, `ANY`, and `SOME` operators [MySQL Docs](https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html) Some simple test cases here; there are more skipped tests in `gms/enginetest/queries/lgoic_test_scripts.go` Set up: ```sql CREATE TABLE c (c_id INT...

This PR: https://github.com/dolthub/go-mysql-server/pull/2095 Fixes some issues regarding nested SubqueryAlias in lateral joins by making these nested subqueries have visibility to the entire left scope. This could potentially cause problems when...

repro ```sql CREATE TABLE test ( pk bigint NOT NULL, c1 bigint, c2 bigint, c3 bigint, c4 bigint, c5 bigint, PRIMARY KEY (pk) ); CREATE TABLE test2 ( pk bigint...