4paradigm / 4paradigm/OpenMLDB
create table add default null
Open
bug
- Dominant language
- C++
- Stars
- 1.7k
- Forks
- 331
- Avg merge
- 12d 12h
- Merged PRs (30d)
- 1
Description
```
> create table t1(c1 string default null);
Error: [2000] default value type mismatch
```
`default null` is needless, but it should pass, and the error is not good.
Contributor guide
Research direction
Look for SQL parser and type checking code related to CREATE TABLE and DEFAULT clause validation. The error 'default value type mismatch' suggests a type validation issue when NULL is specified. Find where default values are validated and ensure NULL is accepted for any column type. Test by creating a table with a string column default null.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 45/100