Debian Codegraph @

mysql-test/suite/versioning/r/autoinc.result

raw
1 create table t1(
2 id int unsigned auto_increment primary key,
3 x int unsigned,
4 y int unsigned,
5 sys_start SYS_DATATYPE as row start invisible,
6 sys_end SYS_DATATYPE as row end invisible,
7 period for system_time (sys_start, sys_end))
8 with system versioning;
9 create table t2(
10 id int unsigned auto_increment primary key,
11 x int unsigned,
12 y int unsigned);
13 insert into t1(x, y) values(1, 11);
14 insert into t2(x, y) values(1, 11);
15 insert into t1(x, y) values(2, 12);
16 insert into t2(x, y) values(2, 12);
17 insert into t1(x, y) values(3, 13);
18 insert into t2(x, y) values(3, 13);
19 insert into t1(x, y) values(4, 14);
20 insert into t2(x, y) values(4, 14);
21 insert into t1(x, y) values(5, 15);
22 insert into t2(x, y) values(5, 15);
23 insert into t1(x, y) values(6, 16);
24 insert into t2(x, y) values(6, 16);
25 insert into t1(x, y) values(7, 17);
26 insert into t2(x, y) values(7, 17);
27 insert into t1(x, y) values(8, 18);
28 insert into t2(x, y) values(8, 18);
29 insert into t1(x, y) values(9, 19);
30 insert into t2(x, y) values(9, 19);
31 select t1.x = t2.x and t1.y = t2.y as A, t1.x, t1.y, t2.x, t2.y from t1 inner join t2 on t1.id = t2.id;
32 A x y x y
33 1 1 11 1 11
34 1 2 12 2 12
35 1 3 13 3 13
36 1 4 14 4 14
37 1 5 15 5 15
38 1 6 16 6 16
39 1 7 17 7 17
40 1 8 18 8 18
41 1 9 19 9 19
42 delete from t1 where x = 2;
43 delete from t2 where x = 2;
44 select t1.x = t2.x and t1.y = t2.y as A, t1.x, t1.y, t2.x, t2.y from t1 inner join t2 on t1.id = t2.id;
45 A x y x y
46 1 1 11 1 11
47 1 3 13 3 13
48 1 4 14 4 14
49 1 5 15 5 15
50 1 6 16 6 16
51 1 7 17 7 17
52 1 8 18 8 18
53 1 9 19 9 19
54 delete from t1 where x > 7;
55 delete from t2 where x > 7;
56 select t1.x = t2.x and t1.y = t2.y as A, t1.x, t1.y, t2.x, t2.y from t1 inner join t2 on t1.id = t2.id;
57 A x y x y
58 1 1 11 1 11
59 1 3 13 3 13
60 1 4 14 4 14
61 1 5 15 5 15
62 1 6 16 6 16
63 1 7 17 7 17
64 drop table t1;
65 drop table t2;
66 #
67 # MDEV-22562 Assertion `next_insert_id == 0' upon UPDATE on system-versioned table
68 #
69 create table t1 (pk integer auto_increment primary key) engine=myisam with system versioning;
70 insert delayed into t1 (pk) values (1);
71 lock tables t1 write;
72 update t1 set pk= 0;
73 update t1 set pk= 0;
74 unlock tables;
75 drop table t1;