Inserting a null default value on a `not null` column does not return correct error message
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 120
Description
The correct error message should be `Field '[col name]' doesn't have a default value` but we instead return `column name '[col name]' is non-nullable but attempted to set a value of null`
We currently have some skip tests for this. Link to this bug added to those tests in dolthub/go-mysql-server#3705
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the skip tests referenced in dolthub/go-mysql-server#3705 and trace the implementation that produces the current non-nullable-null error. Update the behavior so inserting a null default into a not-null column returns the expected “Field '[col name]' doesn't have a default value” message, then use those tests to verify the result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 65/100