diff options
author | Monty <monty@mariadb.org> | 2021-10-06 02:39:59 +0300 |
---|---|---|
committer | Sergei Petrunia <sergey@mariadb.com> | 2023-01-30 15:22:20 +0200 |
commit | 87d4d7232c72b525451972cea28fc50eb7033b29 (patch) | |
tree | ad08a9bc15dbb53336690396c6e908832bc5465f /mysql-test/suite/gcol | |
parent | c443dbff0e46ea5b09588625fecd72a3711a697a (diff) | |
download | mariadb-git-87d4d7232c72b525451972cea28fc50eb7033b29.tar.gz |
Limit calculated rows to the number of rows in the table
The result file changes are mainly that number of rows is one smaller
for some queries with DISTINCT or GROUP BY
Diffstat (limited to 'mysql-test/suite/gcol')
-rw-r--r-- | mysql-test/suite/gcol/r/gcol_select_innodb.result | 2 | ||||
-rw-r--r-- | mysql-test/suite/gcol/r/gcol_select_myisam.result | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_select_innodb.result b/mysql-test/suite/gcol/r/gcol_select_innodb.result index 72d1e9f320c..6fbe4883a51 100644 --- a/mysql-test/suite/gcol/r/gcol_select_innodb.result +++ b/mysql-test/suite/gcol/r/gcol_select_innodb.result @@ -146,7 +146,7 @@ count(distinct c) 3 explain select count(distinct c) from t1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL c 5 NULL 6 Using index for group-by +1 SIMPLE t1 range NULL c 5 NULL 5 Using index for group-by ### ### filesort & range-based utils ### diff --git a/mysql-test/suite/gcol/r/gcol_select_myisam.result b/mysql-test/suite/gcol/r/gcol_select_myisam.result index 0d18976f3bf..d4319d7b555 100644 --- a/mysql-test/suite/gcol/r/gcol_select_myisam.result +++ b/mysql-test/suite/gcol/r/gcol_select_myisam.result @@ -146,7 +146,7 @@ count(distinct c) 3 explain select count(distinct c) from t1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL c 5 NULL 6 Using index for group-by +1 SIMPLE t1 range NULL c 5 NULL 5 Using index for group-by ### ### filesort & range-based utils ### |