diff options
| author | Yuchen Pei <yuchen.pei@mariadb.com> | 2023-05-18 13:11:58 +1000 |
|---|---|---|
| committer | Yuchen Pei <yuchen.pei@mariadb.com> | 2023-05-18 13:11:58 +1000 |
| commit | 7105cb34bc34f029f7a8d4df97e060e726367cef (patch) | |
| tree | 3b2b40b4e15fa1ded43c344fd828e95894e71bde /mysql-test/main/update_use_source.result | |
| parent | 0923515f3807f14b4b4b6c0027e2ce92c0cd9567 (diff) | |
| download | mariadb-git-bb-11.1-mdev-22534.tar.gz | |
MDEV-22534 fixing remaining test regressions with --recordbb-11.1-mdev-22534
All explain output diffs. Looks like either improvements or
inconsequential (not 100% sure), also ran extra selects statements
near the diffs to for sanity check.
Diffstat (limited to 'mysql-test/main/update_use_source.result')
| -rw-r--r-- | mysql-test/main/update_use_source.result | 48 |
1 files changed, 32 insertions, 16 deletions
diff --git a/mysql-test/main/update_use_source.result b/mysql-test/main/update_use_source.result index d756775226c..b7d9383a4a1 100644 --- a/mysql-test/main/update_use_source.result +++ b/mysql-test/main/update_use_source.result @@ -504,11 +504,13 @@ test.t1 analyze status OK explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -1777,11 +1779,13 @@ test.t1 analyze status OK explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -3051,11 +3055,13 @@ test.t1 analyze status OK explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -4324,11 +4330,13 @@ test.t1 analyze status OK explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -5598,11 +5606,13 @@ test.t1 analyze status OK explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -6871,11 +6881,13 @@ test.t1 analyze status OK explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -8145,11 +8157,13 @@ test.t1 analyze note The storage engine for the table doesn't support analyze explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 @@ -9410,11 +9424,13 @@ test.t1 analyze note The storage engine for the table doesn't support analyze explain select * from t1 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1); Using join buffer (flat, BNL join) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 explain update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 32 -1 PRIMARY a ALL NULL NULL NULL NULL 32 Using where; FirstMatch(t1) +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 8 func,func 1 +2 MATERIALIZED a ALL NULL NULL NULL NULL 32 update t1 set c3=c3+110 where c2 in (select distinct a.c2 from t1 a where t1.c1=a.c1); affected rows: 32 info: Rows matched: 32 Changed: 32 Warnings: 0 |