diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-10-06 18:23:40 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-10-06 18:23:40 +0400 |
| commit | e30b6a983fe135dd1af0c79c81dbdb5b14b881c8 (patch) | |
| tree | 284cb101a0da934fa5c742248a8dfffba2d965f3 /mysql-test/t/func_time.test | |
| parent | bea99275de3871ea286ab935d4d9d6fe26dd45b8 (diff) | |
| download | mariadb-git-e30b6a983fe135dd1af0c79c81dbdb5b14b881c8.tar.gz | |
MDEV-11819 NO_ZERO_IN_DATE: Incorrect generated column value
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 92e1c38cec2..7544f9e7761 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -1602,3 +1602,19 @@ DROP TABLE t1; --echo # MDEV-10524 Assertion `arg1_int >= 0' failed in Item_func_additive_op::result_precision() --echo # SELECT 1 MOD ADDTIME( '13:58:57', '00:00:01' ) + 2; + + +--echo # +--echo # MDEV-11819 NO_ZERO_IN_DATE: Incorrect generated column value +--echo # + +SET sql_mode='NO_ZERO_IN_DATE'; +CREATE TABLE t1 (a TIME(6)); +INSERT INTO t1 SELECT timediff(timestamp'2008-12-31 23:59:59.000001',timestamp'2008-12-30 01:01:01.000002'); +SELECT * FROM t1; +DROP TABLE t1; +SET sql_mode=DEFAULT; + +--echo # +--echo # End of 5.5 tests +--echo # |