[MDEV-26943] mysqldump --as-of option ignores hour/minute precision - Jira

Whilst the --as-of option for mysqldump works correctly for dates, it does not work correctly for hour/minute precision.

CREATE TABLE t1 (a INT) WITH SYSTEM VERSIONING;

SET TIMESTAMP=UNIX_TIMESTAMP('1990-01-01 00:00');

INSERT t1 (a) VALUES (1),(2),(3);

SET TIMESTAMP=UNIX_TIMESTAMP('1990-01-01 01:00');

DELETE FROM t1 WHERE a=1;

When dumped with:

./bin/mysqldump -uroot -S./socket.sock --compact --as-of="1990-01-01 00:01" test t1

./bin/mysqldump -uroot -S./socket.sock --compact --as-of="1990-01-01 01:01" test t1

Will produce identical results - the 1 value will be missing.

Similarly,

CREATE TABLE t1 (a INT) WITH SYSTEM VERSIONING;

SET TIMESTAMP=UNIX_TIMESTAMP('1990-01-01 00:00');

INSERT t1 (a) VALUES (1),(2),(3);

SET TIMESTAMP=UNIX_TIMESTAMP('1990-01-02 01:00');

DELETE FROM t1 WHERE a=1;

When dumped with:

./bin/mysqldump -uroot -S./socket.sock --compact --as-of="1990-01-01 00:01" test t1

./bin/mysqldump -uroot -S./socket.sock --compact --as-of="1990-01-02 00:01" test t1

Will produce different results - the 1 value will be missing in the second dump.

There is no reference to "day" only in the manual though ~~MDEV-16355~~ has a comment which refers to "to a specified date".

Proposed fix: either the manual needs to be updated to clarify the limitation, or the feature fixed to correctly process timestamp comparison.

Transition	Time In Source Status	Execution Times

Sergei Golubchik made transition - 2021-10-31 12:33

Open

Confirmed

1d 12h 49m

Sergei Golubchik made transition - 2021-10-31 12:41

Confirmed

Closed

7m 40s

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server