I am doing a Run SQL File to import, and Heidi (10.1.0.5464) is posting error messages.
Inserting a zero-length string on a DECIMAL(16,2) DEFAULT NULL column:
/ SQL Error (1366): Incorrect decimal value: '' for column
captured at row 1 /
Inserting a zero-length string on an ENUM('0','1') NOT NULL DEFAULT '0' column: / SQL Error (1265): Data truncated for column 'free_shipping' at row 1 /
Inserting a zero-length string on a DATE DEFAULT NULL column:
/ SQL Error (1292): Incorrect date value: '' for column
ship_date at row 1 /
Source database for SQL file dump: MySQL 5.6.45 Destination database: MariaDB 10.4.12
The question is:
Are these error messages legitimately coming from MariaDB or are they coming from Heidi complaining about something it doesn't like about the statement?
The above may seem like an ignorant question, but I ask just to eliminate any confusion.
These errors may also from the database's SET SQL_MODE state.