James Cor

Results 60 issues of James Cor

Update queries where there is a cacheable subquery are getting optimized into update joins, which aren't supported for keyless tables. Repro: ```sql create table t (i int); insert into t...

bug
analyzer
good repro
correctness

```sql tmp/main*> create temporary table tmp (i int); tmp/main*> alter table tmp add column (j int); table tmp cannot be altered ```

enhancement
sql
correctness

The plans generated from `TestSingleScript` with and without `harness.UseServer()` can differ. This is a result of `ComPrepare`, which extracts literals and replaces them with BindVars, to be later substituted back...

skipped enginetest here: https://github.com/dolthub/go-mysql-server/pull/2745/files

correctness_approved

correctness_approved

correctness_approved

For some reason, the code implies there may be a mix up in the encodings of Geometry and GeometryEnc, I don't think this was ever the case?

correctness_approved

correctness_approved