Debian Codegraph @

mysql-test/suite/x/r/killconnection_sakiladb.result

raw
1 call mtr.add_suppression("Error in diagnostics area: MY-001317 - Query execution was interrupted");
2 CREATE SCHEMA sakila;
3 USE sakila;
4 CREATE TABLE inventory (
5 inventory_id INT NOT NULL AUTO_INCREMENT,
6 PRIMARY KEY (inventory_id)
7 );
8 CREATE TABLE rental (
9 rental_id INT NOT NULL AUTO_INCREMENT,
10 inventory_id INT NOT NULL,
11 PRIMARY KEY (rental_id),
12 CONSTRAINT fk_rental_inventory FOREIGN KEY (inventory_id) REFERENCES inventory (inventory_id)
13 );
14 CREATE TABLE payment (
15 payment_id INT NOT NULL AUTO_INCREMENT,
16 rental_id INT DEFAULT NULL,
17 amount DECIMAL(5,2) NOT NULL,
18 PRIMARY KEY (payment_id),
19 CONSTRAINT fk_payment_rental FOREIGN KEY (rental_id) REFERENCES rental (rental_id)
20 );
21 RUN START TRANSACTION
22
23 0 rows affected
24 RUN UPDATE sakila.payment SET amount = amount + 1 WHERE payment_id = 5068
25
26 0 rows affected
27 Rows matched: 0 Changed: 0 Warnings: 0
28 connecting...
29 active session is now 'second'
30 RUN SELECT connection_id() AS Value;
31 RUN OPTIMIZE TABLE sakila.inventory;
32 switched to session default
33 RUN KILL $ID
34
35 0 rows affected
36 switched to session second
37 Table Op Msg_type Msg_text
38 sakila.inventory optimize note Table does not support optimize, doing recreate + analyze instead
39 sakila.inventory optimize status Operation failed
40 0 rows affected
41 [ASSERT notice warning - ERROR, 3169]
42 RUN SELECT 1
43 While executing SELECT 1:
44 Got expected error: MySQL server has gone away (code 2006)
45 Server disconnected
46 closing session second
47 switched to session default
48 RUN COMMIT
49
50 0 rows affected
51 Mysqlx.Ok {
52 msg: "bye!"
53 }
54 ok
55 RUN START TRANSACTION
56
57 0 rows affected
58 RUN UPDATE sakila.payment SET amount = amount + 1 WHERE payment_id = 5068
59
60 0 rows affected
61 Rows matched: 0 Changed: 0 Warnings: 0
62 connecting...
63 active session is now 'second'
64 RUN SELECT connection_id() AS Value;
65 RUN SELECT * FROM sakila.inventory;
66 switched to session default
67 RUN KILL $ID
68
69 0 rows affected
70 switched to session second
71 [ASSERT notice warning - ERROR, 3169]
72 Server disconnected
73 closing session second
74 switched to session default
75 RUN COMMIT
76
77 0 rows affected
78 Mysqlx.Ok {
79 msg: "bye!"
80 }
81 ok
82 DROP SCHEMA sakila;