mirror of
https://github.com/MariaDB/server.git
synced 2025-07-14 07:18:12 +02:00
24c57165d5
MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range - Added --update-history option to mariadb-dump to change 2038 row_end timestamp to 2106. - Updated ALTER TABLE ... to convert old row_end timestamps to 2106 timestamp for tables created before MariaDB 11.4.0. - Fixed bug in CHECK TABLE where we wrongly suggested to USE REPAIR TABLE when ALTER TABLE...FORCE is needed. - mariadb-check printed table names that where used with REPAIR TABLE but did not print table names used with ALTER TABLE or with name repair. Fixed by always printing a table that is fixed if --silent is not used. - Added TABLE::vers_fix_old_timestamp() that will change max-timestamp for versioned tables when replication from a pre-11.4.0 server. A few test cases changed. This is caused by: - CHECK TABLE now prints 'Please do ALTER TABLE... instead of 'Please do REPAIR TABLE' when there is a problem with the information in the .frm file (for example a very old frm file). - mariadb-check now prints repaired table names. - mariadb-check also now prints nicer error message in case ALTER TABLE is needed to repair a table.
59 lines
2.6 KiB
Text
59 lines
2.6 KiB
Text
--source include/not_embedded.inc
|
|
--source include/have_partition.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_64bit_timestamp.inc
|
|
|
|
# Test old row_end timestamps from MariaDB 11.3
|
|
|
|
# The original tables where created as follows in 11.3
|
|
|
|
# CREATE TABLE sv_basic (a int NOT NULL PRIMARY KEY) ENGINE=MyISAM
|
|
# WITH SYSTEM VERSIONING;
|
|
# INSERT INTO sv_basic values (1),(2),(3);
|
|
# delete from sv_basic where a=2;
|
|
# select a,row_start,row_end from sv_basic for system_time all;
|
|
#
|
|
# CREATE TABLE sv_partition (a int NOT NULL PRIMARY KEY) engine=MyISAM
|
|
# WITH SYSTEM VERSIONING
|
|
# PARTITION BY SYSTEM_TIME
|
|
# (PARTITION p_hist HISTORY, PARTITION p_cur CURRENT);
|
|
# INSERT INTO sv_partition values (1),(2),(3);
|
|
# delete from sv_partition where a=2;
|
|
# select a,row_start,row_end from sv_partition for system_time all;
|
|
#
|
|
# CREATE TABLE sv_explicit (a int,
|
|
# row_foo_start timestamp(6) as row start,
|
|
# row_foo_end timestamp(6) as row end,
|
|
# period for system_time(row_foo_start,row_foo_end))
|
|
# engine=myisam with system versioning;
|
|
# INSERT INTO sv_explicit (a) values (1),(2),(3);
|
|
# delete from sv_explicit where a=2;
|
|
# select * from sv_explicit for system_time all;
|
|
|
|
let $MARIADB_DATADIR= `select @@datadir`;
|
|
|
|
--copy_file std_data/sv_basic.MYD $MARIADB_DATADIR/test/sv_basic.MYD
|
|
--copy_file std_data/sv_basic.MYI $MARIADB_DATADIR/test/sv_basic.MYI
|
|
--copy_file std_data/sv_basic.frm $MARIADB_DATADIR/test/sv_basic.frm
|
|
--copy_file std_data/sv_explicit.MYD $MARIADB_DATADIR/test/sv_explicit.MYD
|
|
--copy_file std_data/sv_explicit.MYI $MARIADB_DATADIR/test/sv_explicit.MYI
|
|
--copy_file std_data/sv_explicit.frm $MARIADB_DATADIR/test/sv_explicit.frm
|
|
--copy_file std_data/sv_partition#P#p_cur.MYD $MARIADB_DATADIR/test/sv_partition#P#p_cur.MYD
|
|
--copy_file std_data/sv_partition#P#p_cur.MYI $MARIADB_DATADIR/test/sv_partition#P#p_cur.MYI
|
|
--copy_file std_data/sv_partition#P#p_hist.MYD $MARIADB_DATADIR/test/sv_partition#P#p_hist.MYD
|
|
--copy_file std_data/sv_partition#P#p_hist.MYI $MARIADB_DATADIR/test/sv_partition#P#p_hist.MYI
|
|
--copy_file std_data/sv_partition.frm $MARIADB_DATADIR/test/sv_partition.frm
|
|
--copy_file std_data/sv_partition.par $MARIADB_DATADIR/test/sv_partition.par
|
|
|
|
--exec $MYSQL_DUMP --compact --dump-history test
|
|
--exec $MYSQL_DUMP --compact --dump-history --update-history test
|
|
--exec $MYSQL_UPGRADE --force --silent 2>&1
|
|
--remove_file $MARIADB_DATADIR/mariadb_upgrade_info
|
|
|
|
set @@time_zone="+00:00";
|
|
select a,row_end from sv_basic for system_time all;
|
|
select a,row_end from sv_partition for system_time all;
|
|
select a,row_foo_end from sv_explicit for system_time all;
|
|
|
|
drop table sv_basic,sv_partition,sv_explicit;
|
|
|