Debian Codegraph @

mysql-test/suite/ndb/r/ndb_76_inplace_upgrade_triggers.result

raw
1 # Stop MySQL server 1
2 # Stop MySQL server 2
3 # Restore 7.6 backup into NDB
4 # Setup the 7.6 data directory
5 # Copy zip files to tmp
6 # Check that the file exists in the working folder
7 # Unzip the contents
8 # Rename the extracted root directory for server2
9 # Unzip again for server1
10 # Test upgrade on 7.6 data directory on MySQL server 1
11 Pattern "\[ERROR\]" not found
12 # Test upgrade on 7.6 data directory on MySQL server 2
13 Pattern "\[ERROR\]" not found
14 SHOW TABLES;
15 Tables_in_test
16 account
17 t1
18 SHOW TRIGGERS;
19 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
20 ins_transaction INSERT account SET
21 @deposits = @deposits + IF(NEW.amount>0,NEW.amount,0),
22 @withdrawals = @withdrawals + IF(NEW.amount<0,-NEW.amount,0) BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
23 ins_sum INSERT account SET @sum = @sum + NEW.amount BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
24 SHOW TABLES;
25 Tables_in_test
26 account
27 t1
28 SHOW TRIGGERS;
29 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
30 ins_transaction INSERT account SET
31 @deposits = @deposits + IF(NEW.amount>0,NEW.amount,0),
32 @withdrawals = @withdrawals + IF(NEW.amount<0,-NEW.amount,0) BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
33 ins_sum INSERT account SET @sum = @sum + NEW.amount BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
34 SET @sum = 0;
35 SET @deposits = 0;
36 SET @withdrawals = 0;
37 INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00);
38 SELECT * FROM account;
39 acct_num amount
40 137 14.98
41 141 1937.50
42 97 -100.00
43 SELECT @sum AS 'Sum', @deposits AS 'Deposits', @withdrawals AS 'Withdrawals';
44 Sum Deposits Withdrawals
45 1852.48 1952.48 100.00
46 DROP TABLE t1, account;