[MDEV-27749] Binary changes for --as-of and --tz-utc options - Jira

Roel Van de Paar created issue - 2022-02-04 19:41

Aleksey Midenkov made changes - 2022-02-09 16:53

Field	Original Value	New Value
Assignee	Aleksey Midenkov [ midenok ]	Roel Van de Paar [ roel ]

Aleksey Midenkov made changes - 2022-02-09 16:55

Status

Open [ 1 ]

Needs Feedback [ 10501 ]

Roel Van de Paar made changes - 2022-02-16 07:08

Assignee

Roel Van de Paar [ roel ]

Aleksey Midenkov [ midenok ]

Roel Van de Paar made changes - 2022-02-16 07:09

Status

Needs Feedback [ 10501 ]

Open [ 1 ]

Aleksey Midenkov made changes - 2022-02-21 23:11

Assignee

Aleksey Midenkov [ midenok ]

Roel Van de Paar [ roel ]

Aleksey Midenkov made changes - 2022-02-21 23:14

Status

Open [ 1 ]

Needs Feedback [ 10501 ]

Roel Van de Paar made changes - 2022-02-22 20:49

Description

Implement binary changes enumerated in MDEV-26946

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp. Note that table
                      structures are always dumped, irrespective of the date/time specified.
                      Note the interaction of this option with --tz-utc (ref ~~MDEV-26943~~).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Roel Van de Paar made changes - 2022-02-22 20:58

Description

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp. Note that table
                      structures are always dumped, irrespective of the date/time specified.
                      Note the interaction of this option with --tz-utc (ref ~~MDEV-26943~~).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep -A2 -m1 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp. Note that table
                      structures are always dumped, irrespective of the date/time specified.
                      Note the interaction of this option with --tz-utc (ref ~~MDEV-26943~~).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Roel Van de Paar made changes - 2022-02-22 20:59

Link

This issue split from MDEV-26946 [ MDEV-26946 ]

Roel Van de Paar made changes - 2022-02-22 23:04

Status

Needs Feedback [ 10501 ]

Open [ 1 ]

Roel Van de Paar made changes - 2022-02-25 07:13

Description

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep -A2 -m1 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp. Note that table
                      structures are always dumped, irrespective of the date/time specified.
                      Note the interaction of this option with --tz-utc (ref ~~MDEV-26943~~).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep -A3 -m1 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp.
                      Note that table structures are always dumped, irrespective of the
                      date/time specified. Note that the timestamp is interpreted according
                      to the --tz-utc setting (ref ~~MDEV-26943~~).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Roel Van de Paar made changes - 2022-02-25 07:14

Description

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep -A3 -m1 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp.
                      Note that table structures are always dumped, irrespective of the
                      date/time specified. Note that the timestamp is interpreted according
                      to the --tz-utc setting (ref ~~MDEV-26943~~).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Implement binary changes enumerated in MDEV-26946

Proposed texts as per MDEV-26946:

{noformat}
$ ./bin/mysqldump --help --verbose | grep -A3 -m1 'as-of'
  --as-of=name Dump system versioned tables as of the specified timestamp.
                      Note that table structures are always dumped, irrespective of
                      the date/time specified. Note that the timestamp is interpreted
                      according to the --tz-utc setting (ref ~~MDEV-26943~~ and --tz-utc).

$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
  --tz-utc This option enables TIMESTAMP columns to be dumped and
                      reloaded between servers in different time zones.
                      mysqldump sets its connection time zone to UTC before
                      commencing the dump, and adds SET TIME_ZONE=´+00:00´
                      to the top of the dump file.
{noformat}

Aleksey Midenkov made changes - 2022-03-01 10:49

Summary

Implement binary changes enumerated in MDEV-26946

Binary changes for --as-of and --tz-utc options

Aleksey Midenkov made changes - 2022-03-01 10:56

Assignee

Roel Van de Paar [ roel ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2022-04-10 11:16

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2022-04-10 11:16

Status

In Progress [ 3 ]

In Review [ 10002 ]

Sergei Golubchik made changes - 2022-04-10 11:16

Assignee	Sergei Golubchik [ serg ]	Aleksey Midenkov [ midenok ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Aleksey Midenkov made changes - 2022-04-14 13:07

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Aleksey Midenkov made changes - 2022-04-20 08:53

Fix Version/s		10.7.4 [ 27504 ]
Fix Version/s		10.8.3 [ 27502 ]
Fix Version/s	10.7 [ 24805 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Aleksey Midenkov made changes - 2022-05-25 15:55

Link

This issue is caused by ~~MDEV-16355~~ [ ~~MDEV-16355~~ ]

MariaDB Server

Binary changes for --as-of and --tz-utc options

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration