Debian Codegraph @

mysql-test/suite/sql_sequence/temporary.test

raw
1 --source include/have_sequence.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test temporary sequences
6 #
7
8 --echo #
9 --echo # Create
10 --echo #
11
12 create temporary sequence s1 engine=innodb;
13 alter table s1 engine myisam;
14 --disable_ps2_protocol
15 select nextval(s1);
16 --enable_ps2_protocol
17 select * from s1;
18 drop temporary sequence s1;
19
20 --echo #
21 --echo # MDEV-14762 Server crashes in MDL_ticket::has_stronger_or_equal_type
22 --echo # upon inserting into temporary sequence
23 --echo #
24
25 CREATE TEMPORARY SEQUENCE s1 ENGINE=InnoDB;
26 INSERT INTO s1 VALUES (1, 1, 1000, 1, 1, 1, 1, 0);
27 DROP TEMPORARY SEQUENCE s1;
28
29 --echo #
30 --echo # MDEV-13007 ALTER .. ENGINE on temporary sequence may go wrong
31 --echo #
32
33 --disable_ps2_protocol
34 create temporary sequence s1 engine=aria;
35 alter table s1 engine myisam;
36 select nextval(s1);
37 drop temporary sequence s1;
38 create temporary sequence s1 engine=innodb;
39 alter table s1 engine myisam;
40 select nextval(s1);
41 drop temporary sequence s1;
42 create temporary sequence s1;
43 alter table s1 engine innodb;
44 select nextval(s1);
45 select nextval(s1);
46 drop temporary sequence s1;
47 --enable_ps2_protocol
48
49 --echo # End of 10.6 test
50
51 --echo #
52 --echo # MDEV-31298 Assertion `!check_foreigns' failed in trx_mod_table_time_t* trx_t::check_bulk_buffer(dict_table_t*), Assertion `table->skip_alter_undo || !check_unique_secondary' failed in trx_t::check_bulk_buffer
53 --echo #
54 set foreign_key_checks=0,unique_checks=0;
55 create table t1 (c1 char,index (c1)) engine=innodb;
56 xa start 'a';
57 insert into t1 values();
58 set foreign_key_checks=1,unique_checks=1;
59 --error ER_XAER_RMFAIL
60 create temporary sequence f engine=innodb;
61 xa end 'a';
62 xa rollback 'a';
63 drop table t1;
64
65 --echo # End of 10.11 test