Description:
mysql> SET SESSION debug = '+d,skip_dd_table_access_check';
Query OK, 0 rows affected (0.00 sec)
mysql> create table t (a int) stats_persistent = 1;
Query OK, 0 rows affected (5.84 sec)
mysql> SELECT options FROM mysql.tables where name = 't';
+------------------------------------------------------------------------------------------------------------------------------------------------+
| options |
+------------------------------------------------------------------------------------------------------------------------------------------------+
| avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_persistent=4096;stats_sample_pages=0; |
+------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
Noted that the value of stats_persistent is 4096, instead of the expected 1.
How to repeat:
be as above
Suggested fix:
diff --git a/sql/dd/dd_table.cc b/sql/dd/dd_table.cc
index 32e0d28..cbf0d70 100644
--- a/sql/dd/dd_table.cc
+++ b/sql/dd/dd_table.cc
@@ -2077,7 +2077,7 @@ static bool fill_dd_table_from_create_info(
(HA_OPTION_STATS_PERSISTENT | HA_OPTION_NO_STATS_PERSISTENT));
table_options->set("stats_persistent", (create_info->table_options &
- HA_OPTION_STATS_PERSISTENT));
+ HA_OPTION_STATS_PERSISTENT) ? 1 : 0);
}
Description: mysql> SET SESSION debug = '+d,skip_dd_table_access_check'; Query OK, 0 rows affected (0.00 sec) mysql> create table t (a int) stats_persistent = 1; Query OK, 0 rows affected (5.84 sec) mysql> SELECT options FROM mysql.tables where name = 't'; +------------------------------------------------------------------------------------------------------------------------------------------------+ | options | +------------------------------------------------------------------------------------------------------------------------------------------------+ | avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_persistent=4096;stats_sample_pages=0; | +------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) Noted that the value of stats_persistent is 4096, instead of the expected 1. How to repeat: be as above Suggested fix: diff --git a/sql/dd/dd_table.cc b/sql/dd/dd_table.cc index 32e0d28..cbf0d70 100644 --- a/sql/dd/dd_table.cc +++ b/sql/dd/dd_table.cc @@ -2077,7 +2077,7 @@ static bool fill_dd_table_from_create_info( (HA_OPTION_STATS_PERSISTENT | HA_OPTION_NO_STATS_PERSISTENT)); table_options->set("stats_persistent", (create_info->table_options & - HA_OPTION_STATS_PERSISTENT)); + HA_OPTION_STATS_PERSISTENT) ? 1 : 0); }