diff options
| author | Igor Babaev <igor@askmonty.org> | 2022-09-16 22:36:22 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2023-03-15 17:35:22 -0700 |
| commit | e2e3524d7222b713a0c0347fa6a2781e289c3b29 (patch) | |
| tree | 3924b0d87d2692b4ca27b0605468bcc3571da87a /mysql-test/main | |
| parent | c22f7e8e0a8708418d56b5a73115279d6f8e0eba (diff) | |
| download | mariadb-git-e2e3524d7222b713a0c0347fa6a2781e289c3b29.tar.gz | |
Another fix after the latest rebase of commits for MDEV-28883
Diffstat (limited to 'mysql-test/main')
| -rw-r--r-- | mysql-test/main/derived.result | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/main/derived.result b/mysql-test/main/derived.result index e8551957850..7203c9bf67a 100644 --- a/mysql-test/main/derived.result +++ b/mysql-test/main/derived.result @@ -1593,8 +1593,7 @@ where a = ( select * from (select a from t1) dt where dt.a > 5) returning pk, a; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 3 Using where -2 SUBQUERY <derived3> ALL NULL NULL NULL NULL 3 Using where -3 DERIVED t1 ALL NULL NULL NULL NULL 3 Using where +2 SUBQUERY t1 ALL NULL NULL NULL NULL 3 Using where delete from t1 where a = ( select * from (select a from t1) dt where dt.a > 5) returning pk, a; @@ -1633,8 +1632,7 @@ where a <> ( select * from (select a from t1) dt where dt.a > 7) order by a limit 2; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 4 Using where; Using filesort -2 SUBQUERY <derived3> ALL NULL NULL NULL NULL 4 Using where -3 DERIVED t1 ALL NULL NULL NULL NULL 4 Using where +2 SUBQUERY t1 ALL NULL NULL NULL NULL 4 Using where delete from t1 where a <> ( select * from (select a from t1) dt where dt.a > 7) order by a limit 2; |