diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2020-05-29 11:45:19 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2020-05-29 11:45:19 +0300 |
| commit | 57f7b4866f1347ebf3ee67fe61de3871e56e23cc (patch) | |
| tree | 458e73627087c589987e3b13f57f9ee288c02e24 /mysql-test/suite/versioning/t/sysvars.test | |
| parent | 278facee7c7a028d642f3b5f23a42bcf099d86f3 (diff) | |
| download | mariadb-git-57f7b4866f1347ebf3ee67fe61de3871e56e23cc.tar.gz | |
MDEV-16937 Strict SQL with system versioned tables causes issues (10.4)
Respect system fields in NO_ZERO_DATE mode.
This is the subject for refactoring in MDEV-19597
Conflict resolution from 7d5223310789f967106d86ce193ef31b315ecff0
Diffstat (limited to 'mysql-test/suite/versioning/t/sysvars.test')
| -rw-r--r-- | mysql-test/suite/versioning/t/sysvars.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/versioning/t/sysvars.test b/mysql-test/suite/versioning/t/sysvars.test index e82a116f30e..ef5d97ad262 100644 --- a/mysql-test/suite/versioning/t/sysvars.test +++ b/mysql-test/suite/versioning/t/sysvars.test @@ -97,8 +97,8 @@ select * from t for system_time all; select * from t; select * from t for system_time as of timestamp current_timestamp(6); select * from t for system_time all; -select * from t for system_time from '0-0-0' to current_timestamp(6); -select * from t for system_time between '0-0-0' and current_timestamp(6); +select * from t for system_time from '1970-01-01 00:00' to current_timestamp(6); +select * from t for system_time between '1970-01-01 00:00' and current_timestamp(6); show status like "Feature_system_versioning"; |