[MDEV-6287] Bad warning level when inserting a DATETIME value into a TIME column - Jira

This SQL script:

drop table if exists t1;

create table t1 (a time);

insert into t1 values (1.0e+10);

show warnings;

displays a "Warning":

+---------+------+----------------------------------------+

| Level   | Code | Message                                |

+---------+------+----------------------------------------+

| Warning | 1265 | Data truncated for column 'a' at row 1 |

+---------+------+----------------------------------------+

It should be a NOTE instead.

blocks

MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server