diff options
author | Monty <monty@mariadb.org> | 2021-10-05 17:08:16 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2022-07-07 18:15:25 +0300 |
commit | cf10de163eafd5e73f2bd9f3b64f7f65b14e819b (patch) | |
tree | b63606f1c5cd17978814c24f51b2700b7bab9020 /mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result | |
parent | e764e6501bf8d3a647ac4253d4ad03ea0986e708 (diff) | |
download | mariadb-git-cf10de163eafd5e73f2bd9f3b64f7f65b14e819b.tar.gz |
Ensure that test_quick_select doesn't return more rows than in the table
Other changes:
- In test_quick_select(), assume that if table->used_stats_records is 0
then the table has 0 rows.
- Fixed prepare_simple_select() to populate table->used_stat_records
- Enusre that set_statistics_for_tables() doesn't cause used_stats_records
to be 0 when using stat_tables.
- To get blackhole to work with replication, set stats.records to 2 so
that test_quick_select() doesn't assume the table is empty.
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result')
-rw-r--r-- | mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result b/mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result index 91bb2bf3ecd..a6627417d1a 100644 --- a/mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result +++ b/mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result @@ -22,7 +22,7 @@ FROM information_schema.statistics WHERE table_name = 'test_ps_fetch_nonexistent ORDER BY index_name, seq_in_index; seq_in_index 1 column_name a -cardinality 0 +cardinality 1 SELECT table_rows, avg_row_length, max_data_length, index_length FROM information_schema.tables WHERE table_name = 'test_ps_fetch_nonexistent'; table_rows 0 |