diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2020-02-02 15:13:29 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2020-02-02 17:13:58 +0300 |
| commit | b615d275b8c26ecec943003e1275ee19f94d9887 (patch) | |
| tree | fc7881c820dece1cafdec6fd80ae9385b864cc18 /mysql-test/suite/versioning/t/sysvars.test | |
| parent | 5a6023cf6f5f72e36837761f5df0de91c7de62ed (diff) | |
| download | mariadb-git-b615d275b8c26ecec943003e1275ee19f94d9887.tar.gz | |
MDEV-17798 System variable system_versioning_asof accepts wrong values (10.4)
Diffstat (limited to 'mysql-test/suite/versioning/t/sysvars.test')
| -rw-r--r-- | mysql-test/suite/versioning/t/sysvars.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/t/sysvars.test b/mysql-test/suite/versioning/t/sysvars.test index 52fab81b8e6..e82a116f30e 100644 --- a/mysql-test/suite/versioning/t/sysvars.test +++ b/mysql-test/suite/versioning/t/sysvars.test @@ -23,6 +23,14 @@ set global system_versioning_asof= null; set global system_versioning_asof= 1; --error ER_WRONG_TYPE_FOR_VAR set global system_versioning_asof= 1.1; +--error ER_WRONG_VALUE_FOR_VAR +set global system_versioning_asof= '2011-02-29 00:00'; +--error ER_WRONG_VALUE_FOR_VAR +set global system_versioning_asof= '2011-02-28 24:00'; +--error ER_WRONG_VALUE_FOR_VAR +set global system_versioning_asof= '2011-00-28 00:00'; +--error ER_WRONG_VALUE_FOR_VAR +set global system_versioning_asof= '0000-00-00 00:00'; # session --error ER_WRONG_VALUE_FOR_VAR @@ -33,6 +41,14 @@ set system_versioning_asof= null; set system_versioning_asof= 1; --error ER_WRONG_TYPE_FOR_VAR set system_versioning_asof= 1.1; +--error ER_WRONG_VALUE_FOR_VAR +set system_versioning_asof= '2011-02-29 00:00'; +--error ER_WRONG_VALUE_FOR_VAR +set system_versioning_asof= '2011-02-28 24:00'; +--error ER_WRONG_VALUE_FOR_VAR +set system_versioning_asof= '2011-00-28 00:00'; +--error ER_WRONG_VALUE_FOR_VAR +set system_versioning_asof= '0000-00-00 00:00'; --echo # GLOBAL @@system_versioning_asof set global system_versioning_asof= '1911-11-11 11:11:11.1111119'; |