MariaDB connector doesn't allow insertions no data into nonnullable column

[homar]

Following scenario doesn't work for MariaDB

CREATE TABLE test (nullable_col INTEGER, not_null_col INTEGER NOT NULL);

INSERT INTO test (nullable_col) SELECT nationkey FROM nation WHERE regionkey < 0; //nothing is inserted so this should pass, but it doesn't

[findepi]

@martint does the spec define the expected behavior?