matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: insert into values '' to CompositePrimaryKey no error reported

Open heni02 opened this issue 3 years ago • 1 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image

Expected Behavior

No response

Steps to Reproduce

create table cpk_table_21(col1 int,col2 varchar(255),col3 timestamp, col4 double,col5 date,primary key(col1, col2,col5));
insert into cpk_table_21 values (3,'','2019-02-10 00:00:00',78.90,'2001-07-10');

Additional information

No response

heni02 avatar Oct 06 '22 07:10 heni02

i test this problem in mysql, mysql also allow this, so I don't think this is a bug.

bbbearxyz avatar Oct 12 '22 09:10 bbbearxyz

confirm,closed image

heni02 avatar Oct 20 '22 02:10 heni02