diff options
author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-06-25 14:52:38 +0530 |
---|---|---|
committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-06-25 14:52:38 +0530 |
commit | 88aaf590ac9fa8c8030a5831cebd867a7f35478f (patch) | |
tree | 98292a41dce622c8f7de750c067ac87ea6613e98 /mysql-test/main/selectivity_innodb.result | |
parent | 1abd877e2df9e83bc1c2f5195796f427a35bd3f1 (diff) | |
download | mariadb-git-88aaf590ac9fa8c8030a5831cebd867a7f35478f.tar.gz |
MDEV-16365 Setting a column NOT NULL fails to return error for
NULL values when there is no DEFAULT
Copy and inplace algorithm works similarly for
NULL to NOT NULL conversion for the following cases:
(1) strict sql mode - Should give error.
(2) non-strict sql mode - Should give warnings alone
(3) alter ignore table command. - Should give warnings alone.
Diffstat (limited to 'mysql-test/main/selectivity_innodb.result')
-rw-r--r-- | mysql-test/main/selectivity_innodb.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/main/selectivity_innodb.result b/mysql-test/main/selectivity_innodb.result index 236647c6091..332cc947a6b 100644 --- a/mysql-test/main/selectivity_innodb.result +++ b/mysql-test/main/selectivity_innodb.result @@ -1150,6 +1150,7 @@ alter table t1 change column a a int; analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status Engine-independent statistics collected +test.t1 analyze Note Data truncated for column 'avg_frequency' at row 1 test.t1 analyze status OK flush table t1; explain extended select * from t1 where a between 5 and 7; |