Debian Codegraph @

mysql-test/suite/versioning/t/old_timestamp.test

raw
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