Spracherkennung für: .rdiff vermutete Sprache: Abap {ABAP[64] SQL[60] Masm[46]} [Methode: maximale Elemente, drei Dimensionen]
--- innodb_full_scan.result
+++ innodb_full_scan,table_lock.result
@@ -10,14 +10,14 @@
42
COMMIT;
# lock_rec_created
-1
+0
BEGIN;
SELECT * FROM t for update;
a
42
COMMIT;
# lock_rec_created
-1
+0
## SELECT without explicit transaction
SELECT * FROM t;
a
@@ -55,13 +55,13 @@
UNION
select * from t1;
# lock_rec_created
-3
+1
insert into t2
select * from t1
UNION
select * from t1 where t1.a = 10;
# lock_rec_created
-3
+1
insert into t2
select * from t1 where t1.a > 10
UNION
@@ -73,7 +73,7 @@
UNION
select * from t1 where t1.a > 10;
# lock_rec_created
-1
+0
drop table t1, t2;
# CREATE ... SELECT with UNION
create table t1 (a int primary key, b int) engine=innodb;
@@ -83,13 +83,13 @@
UNION
select * from t1;
# lock_rec_created
-3
+1
create or replace table t2 (a int, b int) engine=innodb
select * from t1
UNION
select * from t1 where t1.a = 10;
# lock_rec_created
-3
+1
create or replace table t2 (a int, b int) engine=innodb
select * from t1 where t1.a > 10
UNION
@@ -101,14 +101,14 @@
UNION
select * from t1 where t1.a > 10;
# lock_rec_created
-1
+0
drop table t1, t2;
# UPDATE
create table t1 (a int primary key, b int) engine=innodb;
insert into t1 select seq, seq from seq_1_to_100;
UPDATE t1 SET b = b + 3;
# lock_rec_created
-1
+0
UPDATE t1 SET b = b + 3 WHERE a = 10;
# lock_rec_created
1
@@ -118,7 +118,7 @@
# DELETE
DELETE FROM t1;
# lock_rec_created
-1
+0
DELETE FROM t1 WHERE a = 10;
# lock_rec_created
1
@@ -135,7 +135,7 @@
select * from t1 join t2 on t1.a = t2.a LOCK IN SHARE MODE;
commit;
# lock_rec_created
-2
+1
begin;
select * from t1 join t2 on t1.a = t2.b LOCK IN SHARE MODE;
commit;
@@ -145,7 +145,7 @@
select * from t1 join t2 on t1.b = t2.b LOCK IN SHARE MODE;
commit;
# lock_rec_created
-2
+1
drop table t1, t2;
# Full index scan
create table t10 (a int, b varchar(100), index(a)) engine=innodb;
@@ -153,14 +153,14 @@
create table t11(a int) engine=innodb;
insert into t11 select a from t10;
# lock_rec_created
-11
+0
drop table t10, t11;
create table t10 (a int, b varchar(100), index(a)) engine=innodb;
insert into t10 select seq, uuid() from seq_1_to_10000;
create table t11(a int) engine=innodb;
insert into t11 select a from t10 order by a desc;
# lock_rec_created
-11
+0
drop table t10, t11;
# Range access
create table t10 (a int, b varchar(100), index(a)) engine=innodb;
[Dauer der Verarbeitung: 0.11 Sekunden, vorverarbeitet 2026-10-08]