diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2020-02-02 15:13:29 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2020-02-02 15:13:29 +0300 |
| commit | 006f6f97b10703426c497827c370f84db72c31ef (patch) | |
| tree | c88edec81ef504a3d42ad8eeb0183fb00f6c3dad /mysql-test/suite/versioning/t/sysvars.test | |
| parent | 14e6f0251ccc0056ade6637ea34bb40e72024fcd (diff) | |
| download | mariadb-git-006f6f97b10703426c497827c370f84db72c31ef.tar.gz | |
MDEV-17798 System variable system_versioning_asof accepts wrong values
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 160af12fe02..8c8311d66fc 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'; |