Tim Sehn comments

Results 334 comments of


                                            Tim Sehn

`sql_mode` is always strict

Closing in favor of #2172

`USE db/branch` works differently than `call dolt_checkout('branch')`

@fulghum did you fix this with your current work?

`USE db/branch` works differently than `call dolt_checkout('branch')`

I might close if we can't get more specific.

When updating rows, Dolt requires all values in the row to satisfy constraints, not just the values changed

Just to be clear the example above is against MySQL. We fail the last update statement. ``` test-unique-reorder $ dolt sql DROP TABLE IF EXISTS child; > CREATE TABLE parent(...

When updating rows, Dolt requires all values in the row to satisfy constraints, not just the values changed

This on the other hand works: ``` test-unique-reorder $ dolt sql -q "update child set b = 1, c=1 where a = 101;" Query OK, 1 row affected Rows matched:...

dolt panic when using cli from dbs directory

This will error not panic now. We'll track mixing formats in #4077

Support for selecting non-aggregate expressions that don't appear in GROUP BY clause

I think this might have something to do with this: https://github.com/dolthub/dolt/issues/407#issuecomment-587290825 What version of MySQL are you comparing to?

Support for selecting non-aggregate expressions that don't appear in GROUP BY clause

I'm not arguing that it should not work as you expect. I've run into GROUP BY issues before and some of the parsing is controlled by a MySQL variable, specifically ...

Support for selecting non-aggregate expressions that don't appear in GROUP BY clause

I tested this in another group by and we now suppirt this syntax.

Support for selecting non-aggregate expressions that don't appear in GROUP BY clause

Actually this still busts. Reopening.