| 1 |
--source include/not_embedded.inc |
| 2 |
--source include/have_partition.inc |
| 3 |
--source include/have_innodb.inc |
| 4 |
--source include/have_64bit_timestamp.inc |
| 5 |
|
| 6 |
# Test old row_end timestamps from MariaDB 11.3 |
| 7 |
|
| 8 |
# The original tables where created as follows in 11.3 |
| 9 |
|
| 10 |
# CREATE TABLE sv_basic (a int NOT NULL PRIMARY KEY) ENGINE=MyISAM |
| 11 |
# WITH SYSTEM VERSIONING; |
| 12 |
# INSERT INTO sv_basic values (1),(2),(3); |
| 13 |
# delete from sv_basic where a=2; |
| 14 |
# select a,row_start,row_end from sv_basic for system_time all; |
| 15 |
# |
| 16 |
# CREATE TABLE sv_partition (a int NOT NULL PRIMARY KEY) engine=MyISAM |
| 17 |
# WITH SYSTEM VERSIONING |
| 18 |
# PARTITION BY SYSTEM_TIME |
| 19 |
# (PARTITION p_hist HISTORY, PARTITION p_cur CURRENT); |
| 20 |
# INSERT INTO sv_partition values (1),(2),(3); |
| 21 |
# delete from sv_partition where a=2; |
| 22 |
# select a,row_start,row_end from sv_partition for system_time all; |
| 23 |
# |
| 24 |
# CREATE TABLE sv_explicit (a int, |
| 25 |
# row_foo_start timestamp(6) as row start, |
| 26 |
# row_foo_end timestamp(6) as row end, |
| 27 |
# period for system_time(row_foo_start,row_foo_end)) |
| 28 |
# engine=myisam with system versioning; |
| 29 |
# INSERT INTO sv_explicit (a) values (1),(2),(3); |
| 30 |
# delete from sv_explicit where a=2; |
| 31 |
# select * from sv_explicit for system_time all; |
| 32 |
|
| 33 |
let $MARIADB_DATADIR= `select @@datadir`; |
| 34 |
|
| 35 |
--copy_file std_data/sv_basic.MYD $MARIADB_DATADIR/test/sv_basic.MYD |
| 36 |
--copy_file std_data/sv_basic.MYI $MARIADB_DATADIR/test/sv_basic.MYI |
| 37 |
--copy_file std_data/sv_basic.frm $MARIADB_DATADIR/test/sv_basic.frm |
| 38 |
--copy_file std_data/sv_explicit.MYD $MARIADB_DATADIR/test/sv_explicit.MYD |
| 39 |
--copy_file std_data/sv_explicit.MYI $MARIADB_DATADIR/test/sv_explicit.MYI |
| 40 |
--copy_file std_data/sv_explicit.frm $MARIADB_DATADIR/test/sv_explicit.frm |
| 41 |
--copy_file std_data/sv_partition#P#p_cur.MYD $MARIADB_DATADIR/test/sv_partition#P#p_cur.MYD |
| 42 |
--copy_file std_data/sv_partition#P#p_cur.MYI $MARIADB_DATADIR/test/sv_partition#P#p_cur.MYI |
| 43 |
--copy_file std_data/sv_partition#P#p_hist.MYD $MARIADB_DATADIR/test/sv_partition#P#p_hist.MYD |
| 44 |
--copy_file std_data/sv_partition#P#p_hist.MYI $MARIADB_DATADIR/test/sv_partition#P#p_hist.MYI |
| 45 |
--copy_file std_data/sv_partition.frm $MARIADB_DATADIR/test/sv_partition.frm |
| 46 |
--copy_file std_data/sv_partition.par $MARIADB_DATADIR/test/sv_partition.par |
| 47 |
|
| 48 |
--exec $MYSQL_DUMP --no-autocommit=0 --compact --dump-history test |
| 49 |
--exec $MYSQL_DUMP --no-autocommit=0 --compact --dump-history --update-history test |
| 50 |
--exec $MYSQL_UPGRADE --force --silent 2>&1 |
| 51 |
--remove_file $MARIADB_DATADIR/mariadb_upgrade_info |
| 52 |
|
| 53 |
set @@time_zone="+00:00"; |
| 54 |
select a,row_end from sv_basic for system_time all; |
| 55 |
select a,row_end from sv_partition for system_time all; |
| 56 |
select a,row_foo_end from sv_explicit for system_time all; |
| 57 |
|
| 58 |
drop table sv_basic,sv_partition,sv_explicit; |
| 59 |
|