Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/main/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 19 kB

Quelle mysqlbinlog_row_compressed.result Sprache: Lisp

set pseudo_thread_id=5;
reset master;
SET GLOBAL log_bin_compress=on;
SET GLOBAL log_bin_compress_min_len=10;
CREATE TABLE t1 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 TINYINT, f4 MEDIUMINT, f5 BIGINT, f6 INT, f7 INT, f8 char(1)) CHARSET=latin1 COLLATE latin1_swedish_ci;
CREATE TABLE t2 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 INT, f4 INT, f5 MEDIUMINT, f6 INT, f7 INT, f8 char(1)) CHARSET=latin1 COLLATE latin1_swedish_ci;
INSERT INTO t1 VALUES (10, 1, 2, 3, 4, 5, 6, 7, "");
INSERT INTO t1 VALUES (11, 1, 2, 3, 4, 5, 6, 7, NULL);
INSERT INTO t1 VALUES (12, 1, 2, 3, NULL, 5, 6, 7, "A");
INSERT INTO t1 VALUES (13, 1, 2, 3, 0, 5, 6, 7, "A");
INSERT INTO t2 SELECT * FROM t1;
UPDATE t2 SET f4=5 WHERE f4>0 or f4 is NULL;
DELETE FROM t1;
DELETE FROM t2;
FLUSH BINARY LOGS;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Start: xxx
ROLLBACK/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Gtid list []
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Binlog checkpoint master-bin.000001
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-1 ddl thread_id=TID
/*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
/*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*M!100001 SET @@session.server_id=1*//*!*/;
/*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query_compressed thread_id=TID exec_time=x error_code=0 xid=<xid>
use `test`/*!*/;
SET TIMESTAMP=X/*!*/;
SET @@session.pseudo_thread_id=TID/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
SET @@session.sql_mode=#/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=#/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE TABLE t1 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 TINYINT, f4 MEDIUMINT, f5 BIGINT, f6 INT, f7 INT, f8 char(1)) CHARSET=latin1 COLLATE latin1_swedish_ci
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-2 ddl thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query_compressed thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
CREATE TABLE t2 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 INT, f4 INT, f5 MEDIUMINT, f6 INT, f7 INT, f8 char(1)) CHARSET=latin1 COLLATE latin1_swedish_ci
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-3 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> INSERT INTO t1 VALUES (10, 1, 2, 3, 4, 5, 6, 7, "")
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t1` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Write_compressed_rows: table id <tblid> flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=10 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=4 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 1
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-4 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> INSERT INTO t1 VALUES (11, 1, 2, 3, 4, 5, 6, 7, NULL)
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t1` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Write_compressed_rows: table id <tblid> flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=11 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=4 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9=NULL /* STRING(1) meta=65025 nullable=1 is_null=1 */
# Number of rows: 1
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-5 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> INSERT INTO t1 VALUES (12, 1, 2, 3, NULL, 5, 6, 7, "A")
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t1` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Write_compressed_rows: table id <tblid> flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=12 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=NULL /* MEDIUMINT meta=0 nullable=1 is_null=1 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 1
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-6 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> INSERT INTO t1 VALUES (13, 1, 2, 3, 0, 5, 6, 7, "A")
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t1` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Write_compressed_rows: table id <tblid> flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=13 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=0 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 1
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-7 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> INSERT INTO t2 SELECT * FROM t1
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t2` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Write_compressed_rows: table id <tblid> flags: STMT_END_F
### INSERT INTO `test`.`t2`
### SET
###   @1=10 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=4 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###   @1=11 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=4 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9=NULL /* STRING(1) meta=65025 nullable=1 is_null=1 */
### INSERT INTO `test`.`t2`
### SET
###   @1=12 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=NULL /* INT meta=0 nullable=1 is_null=1 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###   @1=13 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=0 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 4
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-8 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> UPDATE t2 SET f4=5 WHERE f4>0 or f4 is NULL
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t2` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Update_compressed_rows: table id <tblid> flags: STMT_END_F
### UPDATE `test`.`t2`
### WHERE
###   @1=10 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=4 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### SET
###   @1=10 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=5 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=11 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=4 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9=NULL /* STRING(1) meta=65025 nullable=1 is_null=1 */
### SET
###   @1=11 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=5 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9=NULL /* STRING(1) meta=65025 nullable=1 is_null=1 */
### UPDATE `test`.`t2`
### WHERE
###   @1=12 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=NULL /* INT meta=0 nullable=1 is_null=1 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### SET
###   @1=12 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=5 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 3
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-9 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> DELETE FROM t1
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t1` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Delete_compressed_rows: table id <tblid> flags: STMT_END_F
### DELETE FROM `test`.`t1`
### WHERE
###   @1=10 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=4 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### DELETE FROM `test`.`t1`
### WHERE
###   @1=11 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=4 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9=NULL /* STRING(1) meta=65025 nullable=1 is_null=1 */
### DELETE FROM `test`.`t1`
### WHERE
###   @1=12 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=NULL /* MEDIUMINT meta=0 nullable=1 is_null=1 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### DELETE FROM `test`.`t1`
### WHERE
###   @1=13 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* TINYINT meta=0 nullable=1 is_null=0 */
###   @5=0 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @6=5 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 4
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  GTID 0-1-10 thread_id=TID
/*M!100001 SET @@session.gtid_seq_no=10*//*!*/;
START TRANSACTION
/*!*/;
# at <pos>
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Annotate_rows:
#Q> DELETE FROM t2
#<date> server id 1  end_log_pos # CRC32 XXX  Table_map: `test`.`t2` mapped to number num
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Delete_compressed_rows: table id <tblid> flags: STMT_END_F
### DELETE FROM `test`.`t2`
### WHERE
###   @1=10 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=5 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
###   @1=11 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=5 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9=NULL /* STRING(1) meta=65025 nullable=1 is_null=1 */
### DELETE FROM `test`.`t2`
### WHERE
###   @1=12 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=5 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
###   @1=13 /* INT meta=0 nullable=0 is_null=0 */
###   @2=1 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4=3 /* INT meta=0 nullable=1 is_null=0 */
###   @5=0 /* INT meta=0 nullable=1 is_null=0 */
###   @6=5 /* MEDIUMINT meta=0 nullable=1 is_null=0 */
###   @7=6 /* INT meta=0 nullable=1 is_null=0 */
###   @8=7 /* INT meta=0 nullable=1 is_null=0 */
###   @9='A' /* STRING(1) meta=65025 nullable=1 is_null=0 */
# Number of rows: 4
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Query thread_id=TID exec_time=x error_code=0 xid=<xid>
SET TIMESTAMP=X/*!*/;
COMMIT
/*!*/;
# at <pos>
#<date> server id 1  end_log_pos # CRC32 XXX  Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

Test mysqlbinlog | mysql type point-in-time recovery with compressed events.

FLUSH BINARY LOGS;
CREATE TABLE t3 (a INT PRIMARY KEY, b INT, c VARCHAR(100)) CHARSET=latin1 COLLATE latin1_swedish_ci;
INSERT INTO t3 VALUES (0, 10, "hello");
BEGIN;
INSERT INTO t3 VALUES (1, 10, "cat"), (2, 10, "mouse"), (3, 10, "dog");
INSERT INTO t3 VALUES (4, 10, "goodbye");
COMMIT;
UPDATE t3 SET b=b+100 where a<>1;
DELETE FROM t3 WHERE a=2;
SET @old_image=@@binlog_row_image;
SET binlog_row_image=minimal;
INSERT INTO t3 VALUES (5, 20, "red"), (6, 30, "green"), (7, 40, "blue");
INSERT INTO t3 VALUES (8, 20, "rigel");
UPDATE t3 SET c = concat("colour of ", c) WHERE a > 5;
UPDATE t3 SET b=b*2 WHERE a IN (5,6,7);
DELETE FROM t3 WHERE a=6;
SET binlog_row_image=@old_image;
SELECT * FROM t3 ORDER BY a;
a b c
0 110 hello
1 10 cat
3 110 dog
4 110 goodbye
5 40 red
7 80 colour of blue
8 20 colour of rigel
FLUSH LOGS;
DROP TABLE t3;
SELECT * FROM t3 ORDER BY a;
a b c
0 110 hello
1 10 cat
3 110 dog
4 110 goodbye
5 40 red
7 80 colour of blue
8 20 colour of rigel
DROP TABLE t1,t2,t3;
SET GLOBAL log_bin_compress=off;
SET GLOBAL log_bin_compress_min_len=256;

Messung V0.5 in Prozent

¤ Dauer der Verarbeitung: 0.14 Sekunden (vorverarbeitet am 2026-10-08) ¤

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.