James Cor

This PR fixes the queries mentioned in this issue: https://github.com/dolthub/go-mysql-server/pull/2294 However, the fix is more of a point fix and does not fully address the varierty of type comparisons used...

That's a good idea. We should also add tests for multiple zeros, negative values (specificically -0.0), and scientific notation ``` 123.0...0 -0.0...0 123e3 -123.4e-2 ```

Hey @tim-oh-thee, Just wanted to make sure we are on the same page. You want support for the other `where_conditions` in `DECALRE ... HANDLER ...`: https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html Not support for the...

Hey @vmg, GMS behavior here has changed. We currently always return `DOUBLE` regardless of the input types (this might also be the case for `COUNT`). We can start fixing this...

We've added a way to deal with database collation changes, describe here: https://github.com/dolthub/dolt/issues/7815#issuecomment-2105274869

Here's a summary of MySQL Server vs Status variables: https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html (it seems like all Status variables start with a capital letter)

fixed in: https://github.com/dolthub/go-mysql-server/pull/2576