search

dolthub / dolt

Dolt – Git for Data
https://www.dolthub.com
Apache License 2.0
17.99k stars 516 forks source link

Support `SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'` #8584

Closed timsehn closed 3 days ago

timsehn commented 3 days ago

A user has a dump that uses:

/*!40101 SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO,'*/

This fails with:

Failed to execute statement: value  was not found in the set (1105)

I think it is an unsupported value. But I'm also not sure if the trailing comma messes us up.