[MDEV-27725] mroonga/storage.column_datetime_freebsd_before_unix_epoch fails with ER_WARN_DATA_OUT_OF_RANGE Created: 2022-02-02  Updated: 2022-02-02

Status: Open
Project: MariaDB Server
Component/s: Platform FreeBSD, Storage Engine - Mroonga, Tests
Affects Version/s: 10.5
Fix Version/s: 10.5

Type: Bug Priority: Trivial
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

FreeBSD 13



 Description   

Other versions are likely affected too, I didn't check

The test is specific for FreeBSD, yet it fails on FreeBSD. I'm not sure what it tried to achieve and why it was specific to FreeBSD. The error is not MTR-specific, the same CREATE/INSERT fails the same way on a manually started server on FreeBSD, but not on Linux.

CURRENT_TEST: mroonga/storage.column_datetime_freebsd_before_unix_epoch
mysqltest: At line 30: query 'INSERT INTO diaries (title, created_at)
VALUES ('1000-01-01 00:00:00', '1000-01-01 00:00:00')' failed: 1264: Out of range value for column 'created_at' at row 1
 
The result from queries just before the failure was:
DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
created_at DATETIME
) DEFAULT CHARSET UTF8;
INSERT INTO diaries (title, created_at)
VALUES ('1000-01-01 00:00:00', '1000-01-01 00:00:00');


Generated at Thu Feb 08 09:55:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.