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 | |
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')
-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 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 ### diff --git a/mysql-test/suite/gcol/r/gcol_select_myisam.result b/mysql-test/suite/gcol/r/gcol_select_myisam.result index 67c495f6a6e..a29fc0a32ee 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 ### |