James Cor

Results 27 comments of James Cor

Hey @latot and @dlscanada. It's been a little less than a year, but `SPATIAL` indexes are now supported (and enabled by default) as of dolt release `v0.75.1`! Please try them...

Maybe related? https://github.com/dolthub/dolt/issues/4925

The syntax error is caused by recent changes dealing with reserved keywords. This new behavior is expected since `row_number` is a [reserved keyword](https://dev.mysql.com/doc/refman/8.0/en/keywords.html#:~:text=ROW_FORMAT-,ROW_NUMBER,-(R)%3B%20added%20in). Wrapping the `row_number` in backquotes gets us...

I dug into this a little and it's weird... I think this is mostly a problem with git bash itself, the same thing also happens when trying to run the...

Hey @ericmock, thanks for the bug report! It seems like dBeaver is doing something strange when trying to edit result sets from branches that the server isn't on. I'm currently...

Hey @florianlaws, the fix for this has been merged to main, and a release for it will be out sometime this week.

fix is merged to gms, main will eventually make it to dolt main

Update here. When converting between types for our indexes, we pick the type that the column in the key is defined over. It appears that MySQL has different rules for...

Additionally, certain intervals are not `NULL` in MySQL, but cause overflows in `time.Duration` dolt. MySQL: ```sql mysql> select date_add("2008-01-02", interval 1000000 day); +----------------------------------------------+ | date_add("2008-01-02", interval 1000000 day) | +----------------------------------------------+...