mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 01:45:33 +01:00
c443dbff0e
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.
32 lines
1.2 KiB
Text
32 lines
1.2 KiB
Text
call mtr.add_suppression("InnoDB: Error: Fetch of persistent statistics requested for table *");
|
|
CREATE TABLE test_ps_fetch_nonexistent
|
|
(a INT, PRIMARY KEY (a))
|
|
ENGINE=INNODB STATS_PERSISTENT=1;
|
|
ANALYZE TABLE test_ps_fetch_nonexistent;
|
|
Table test.test_ps_fetch_nonexistent
|
|
Op analyze
|
|
Msg_type status
|
|
Msg_text Engine-independent statistics collected
|
|
Table test.test_ps_fetch_nonexistent
|
|
Op analyze
|
|
Msg_type status
|
|
Msg_text OK
|
|
SELECT COUNT(*)
|
|
FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
|
|
COUNT(*) 1
|
|
DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_fetch_nonexistent';
|
|
DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
|
|
FLUSH TABLE test_ps_fetch_nonexistent;
|
|
SELECT seq_in_index, column_name, cardinality
|
|
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 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
|
|
avg_row_length 0
|
|
max_data_length 0
|
|
index_length 0
|
|
DROP TABLE test_ps_fetch_nonexistent;
|