Debian Codegraph @

mysql-test/suite/maria/maria-connect.result

raw
1 set global default_storage_engine=aria;
2 set session default_storage_engine=aria;
3 drop table if exists t1;
4 SET SQL_WARNINGS=1;
5 RESET MASTER;
6 set binlog_format=statement;
7 CREATE TABLE t1 (a int primary key);
8 insert t1 values (1),(2),(3);
9 insert t1 values (4),(2),(5);
10 ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
11 show warnings;
12 Level Code Message
13 Error 1062 Duplicate entry '2' for key 'PRIMARY'
14 Note 4173 Engine Aria does not support rollback. Changes were committed during rollback call
15 Warning 1196 Some non-transactional changed tables couldn't be rolled back
16 select * from t1;
17 a
18 1
19 2
20 3
21 4
22 SHOW BINLOG EVENTS FROM <start_pos>;
23 Log_name Pos Event_type Server_id End_log_pos Info
24 master-bin.000001 # Gtid_list 1 # []
25 master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001
26 master-bin.000001 # Gtid 1 # GTID 0-1-1
27 master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (a int primary key)
28 master-bin.000001 # Gtid 1 # BEGIN GTID 0-1-2
29 master-bin.000001 # Query 1 # use `test`; insert t1 values (1),(2),(3)
30 master-bin.000001 # Query 1 # COMMIT
31 master-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3
32 master-bin.000001 # Query 1 # use `test`; insert t1 values (4),(2),(5)
33 master-bin.000001 # Query 1 # COMMIT
34 drop table t1;
35 set binlog_format=default;