matrixorigin
[Bug]: insert ignore into decimal type not null results error
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Branch Name
main
Commit ID
85734e607d12a7a34ac31f8cdc91e72d9eaf98e3
Other Environment Information
- Hardware parameters:
- OS type:
- Others:
Actual Behavior
insert ignore into decimal type not null 按目前mo支持情况应该报null约束错误，但现在可以插入成功，且插入一行数据也是错误的
如果不能复现，drop表后再create表insert
Expected Behavior
No response
Steps to Reproduce
create table insert_ignore_04 (product_id INT NOT NULL AUTO_INCREMENT,product_name VARCHAR(255) NOT NULL,quantity_in_stock INT DEFAULT 0,price DECIMAL(10, 2) NOT NULL,PRIMARY KEY (product_id));
insert ignore into insert_ignore_04(product_name, price) VALUES('Laptop', 1200.00),('Monitor', 150.00),('Keyboard', NULL),('Mouse', 15.00);
Additional information
No response
verified with https://github.com/matrixorigin/matrixone/commit/0a5786af3da2735110732c94427e15221d365fe6
@heni02 please double check and add bvt case, thank you
confirm，closed commit:0a3d52f3f9b4c740744f8567e689fed784feffe5 mysql> create table insert_ignore_04 (product_id INT NOT NULL AUTO_INCREMENT,product_name VARCHAR(255) NOT NULL,quantity_in_stock INT DEFAULT 0,price DECIMAL(10, 2) NOT NULL,PRIMARY KEY (product_id)); Query OK, 0 rows affected (0.05 sec)
mysql> insert ignore into insert_ignore_04(product_name, price) VALUES('Laptop', 1200.00),('Monitor', 150.00),('Keyboard', NULL),('Mouse', 15.00); ERROR 3819 (HY000): constraint violation: Column 'price' cannot be null
Hello @heni02. The bug issue in the BVT test code has not been removed,issues automatically open.
