matrixorigin / matrixorigin/matrixone

[Bug]: internal error: panic the `expr` must be integral constant expression when creating partition table with null value

Open
#18,694 0 comments 0 reactions 1 assignee Claimed by @ck89119 View on GitHub
area/partition deferred kind/bug
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same bug?

- [X] I have checked the existing issues.

### Branch Name

main

### Commit ID

b2d8e4aefb0d7b3b3d7deb19a772c6bbfa973a9f

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

mysql> CREATE TABLE t1 (a int) PARTITION BY RANGE(a) (PARTITION p0 VALUES LESS THAN (NULL));
ERROR 20101 (HY000): internal error: panic the `expr` must be integral constant expression:
github.com/matrixorigin/matrixone/pkg/sql/plan.getIntConstVal[...]
/Users/sudong/Program/MatrixOrigin/matrixone/pkg/sql/plan/partition_util.go:1024
github.com/matrixorigin/matrixone/pkg/sql/plan.getRangeValue
/Users/sudong/Program/MatrixOrigin/matrixone/pkg/sql/plan/partition_util.go:929
github.com/matrixorigin/matrixone/pkg/sql/plan.checkRangePartitionValue
/Users/sudong/Program/MatrixOrigin/matrixone/pkg/sql/plan/partition_util.go

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
CREATE TABLE t1 (a int)
PARTITION BY RANGE(a)
(PARTITION p0 VALUES LESS THAN (NULL));
```

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.