diff options
author | Monty <monty@mariadb.org> | 2021-10-06 02:39:59 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2021-12-27 19:47:35 +0200 |
commit | b25fa384d20fa5f87b319e2117ab08a30b3329aa (patch) | |
tree | 4b04da48bac11a0b90e5abd51c2c783e341c40bf /mysql-test/suite/gcol/r/gcol_select_innodb.result | |
parent | 1cad86ac1bf2a593348cd978b8d6df4e0f55db4b (diff) | |
download | mariadb-git-b25fa384d20fa5f87b319e2117ab08a30b3329aa.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/r/gcol_select_innodb.result')
-rw-r--r-- | mysql-test/suite/gcol/r/gcol_select_innodb.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_select_innodb.result b/mysql-test/suite/gcol/r/gcol_select_innodb.result index 17acbcf2bb2..8ff8a8e3dd9 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 ### |