4paradigm / 4paradigm/OpenMLDB

create table add default null

Open
#3,853 0 comments 0 reactions 1 assignee Claimed by @vagetablechicken View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.