summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2021-10-05 17:08:16 +0300
committerMonty <monty@mariadb.org>2022-07-07 18:15:25 +0300
commitcf10de163eafd5e73f2bd9f3b64f7f65b14e819b (patch)
treeb63606f1c5cd17978814c24f51b2700b7bab9020 /mysql-test/suite/innodb/r/innodb_stats_fetch_nonexistent.result
parente764e6501bf8d3a647ac4253d4ad03ea0986e708 (diff)
downloadmariadb-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.result2
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