diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-01 18:15:00 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-01 18:15:00 +0000 |
| commit | a2a2e32c02643a0cec111511220227703fda1cd5 (patch) | |
| tree | 69cc2b631234c2a8e026b9cd4d72676c61c594df /mysql-test/main/analyze_stmt_orderby.test | |
| parent | Releasing progress-linux version 1:10.11.8-1~progress7.99u1. (diff) | |
| download | mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.tar.xz mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.zip | |
Merging upstream version 1:11.4.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/main/analyze_stmt_orderby.test')
| -rw-r--r-- | mysql-test/main/analyze_stmt_orderby.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/analyze_stmt_orderby.test b/mysql-test/main/analyze_stmt_orderby.test index ecee8040..519cae45 100644 --- a/mysql-test/main/analyze_stmt_orderby.test +++ b/mysql-test/main/analyze_stmt_orderby.test @@ -21,6 +21,7 @@ insert into t2 select A.a*1000 + B.a, A.a*1000 + B.a from t0 A, t1 B; --echo # explain update t2 set b=b+1 order by b limit 5; +--source include/explain-no-costs.inc explain format=json update t2 set b=b+1 order by b limit 5; --source include/analyze-format.inc @@ -32,6 +33,7 @@ update t2 set b=b+1 order by b limit 5; --echo # explain update t2 set a=a+1 where a<10; +--source include/explain-no-costs.inc explain format=json update t2 set a=a+1 where a<10; --source include/analyze-format.inc @@ -43,6 +45,7 @@ update t2 set a=a+1 where a<10; --echo # explain delete from t2 order by b limit 5; +--source include/explain-no-costs.inc explain format=json delete from t2 order by b limit 5; --source include/analyze-format.inc @@ -54,6 +57,7 @@ delete from t2 order by b limit 5; --echo # explain select * from t0,t2 where t2.a=t0.a order by t2.b limit 4; +--source include/explain-no-costs.inc explain format=json select * from t0,t2 where t2.a=t0.a order by t2.b limit 4; --source include/analyze-format.inc @@ -66,6 +70,7 @@ select * from t0,t2 where t2.a=t0.a order by t2.b limit 4; --echo # explain select * from t0,t2 where t2.a=t0.a order by t0.a limit 4; +--source include/explain-no-costs.inc explain format=json select * from t0,t2 where t2.a=t0.a order by t0.a limit 4; --source include/analyze-format.inc @@ -143,6 +148,7 @@ select count(distinct t5.b) as sum from t5, t6 where t5.a=t6.a and t6.b > 0 and t5.a <= 5 group by t5.a order by sum limit 1; +--source include/explain-no-costs.inc explain format=json select count(distinct t5.b) as sum from t5, t6 where t5.a=t6.a and t6.b > 0 and t5.a <= 5 |