在mysql 7中无法使用复杂的check约束条件验证数据

DELIMITER $$
CREATE TRIGGER check_dates_before_insert
BEFORE INSERT ON complex_example
FOR EACH ROW
BEGIN
    IF NEW.start_date >= NEW.end_date OR YEAR(NEW.start_date) != YEAR(NEW.end_date) THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Invalid dates: start_date must be before end_date and in the same year';
    END IF;
END$$
DELIMITER ;

def validate_dates(start_date, end_date):
    if start_date >= end_date or start_date.year != end_date.year:
        raise ValueError("Invalid dates: start_date must be before end_date and in the same year")

# 在插入数据前调用验证函数
validate_dates(start_date_obj, end_date_obj)

CREATE TABLE complex_example (
    id INT PRIMARY KEY,
    start_date DATE,
    end_date DATE,
    CHECK (start_date < end_date AND YEAR(start_date) = YEAR(end_date))
);