dolthub / dolthub/dolt

Inserting a null default value on a `not null` column does not return correct error message

Open
#11,608 0 comments 0 reactions 0 assignees View on GitHub
bad 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.