- 8.0.17 - release

rm -rf 97172/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/97172 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/97172 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=$PWD/97172/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &

-
CREATE DATABASE IF NOT EXISTS test;
use test;
SET debug='+d,skip_dd_table_access_check';
CREATE TABLE tbl_int (col1 int);
INSERT mysql.column_statistics VALUES (1, 1, unhex("746573741F74626C5F696E741F636F6C31"),"test", "tbl_int", "col1","{\"histogram-type\":\"dummy\",\"data-type\":\"int\"}",NULL);
select * from information_schema.column_statistics;
INSERT tbl_int VALUES (1);
select * from tbl_int;
drop table tbl_int;
show tables;
----
bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.17 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE IF NOT EXISTS test;
Query OK, 1 row affected (0.01 sec)

mysql> use test;
Database changed
mysql> SET debug='+d,skip_dd_table_access_check';
ERROR 1193 (HY000): Unknown system variable 'debug'
mysql> CREATE TABLE tbl_int (col1 int);
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT mysql.column_statistics VALUES (1, 1, unhex("746573741F74626C5F696E741F636F6C31"),"test", "tbl_int", "col1","{\"histogram-type\":\"dummy\",\"data-type\":\"int\"}",NULL);
ERROR 3554 (HY000): Access to data dictionary table 'mysql.column_statistics' is rejected.
mysql> select * from information_schema.column_statistics;
Empty set (0.00 sec)

mysql> INSERT tbl_int VALUES (1);
Query OK, 1 row affected (0.01 sec)

mysql> select * from tbl_int;
+------+
| col1 |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

mysql> drop table tbl_int;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
Empty set (0.00 sec)

mysql>

--

- debug build

rm -rf 97172/
bin/mysqld-debug --initialize-insecure --basedir=$PWD --datadir=$PWD/97172 --log-error-verbosity=3
bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/97172 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=$PWD/97172/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &


-
CREATE DATABASE IF NOT EXISTS test;
use test;

SET debug='+d,skip_dd_table_access_check';
CREATE TABLE tbl_int (col1 int);

INSERT mysql.column_statistics VALUES (1, 1, unhex("746573741F74626C5F696E741F636F6C31"),"test", "tbl_int", "col1","{\"histogram-type\":\"dummy\",\"data-type\":\"int\"}",NULL);
INSERT tbl_int VALUES (1);

-
 bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.17-debug MySQL Community Server - GPL - Debug

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE IF NOT EXISTS test;
Query OK, 1 row affected (0.02 sec)

mysql> use test;
Database changed
mysql>
mysql> SET debug='+d,skip_dd_table_access_check';
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE tbl_int (col1 int);
Query OK, 0 rows affected (0.03 sec)

mysql>
mysql> INSERT mysql.column_statistics VALUES (1, 1, unhex("746573741F74626C5F696E741F636F6C31"),"test", "tbl_int", "col1","{\"histogram-type\":\"dummy\",\"data-type\":\"int\"}",NULL);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT tbl_int VALUES (1);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> \q
Bye
[1]+  Aborted                 (core dumped) bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/97172 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/97172/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1

(gdb) bt
#0  0x00007ff21e897771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000004048186 in my_write_core (sig=6) at ../../mysql-8.0.17/mysys/stacktrace.cc:305
#2  0x0000000002e25dc3 in handle_fatal_signal (sig=6) at ../../mysql-8.0.17/sql/signal_handler.cc:168
#3  <signal handler called>
#4  0x00007ff21cbe65d7 in raise () from /lib64/libc.so.6
#5  0x00007ff21cbe7cc8 in abort () from /lib64/libc.so.6
#6  0x00007ff21cbdf546 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007ff21cbdf5f2 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000003f17569 in dd::cache::Storage_adapter::get<dd::Item_name_key, dd::Column_statistics> (thd=0x7ff150000c00, key=..., isolation=ISO_READ_COMMITTED, bypass_core_registry=false, object=0x7ff2080b4810)
    at ../../mysql-8.0.17/sql/dd/impl/cache/storage_adapter.cc:189
#9  0x0000000003f0fc88 in dd::cache::Shared_dictionary_cache::get_uncached<dd::Item_name_key, dd::Column_statistics> (this=0x7132e20 <dd::cache::Shared_dictionary_cache::instance()::s_cache>, thd=0x7ff150000c00, key=...,
    isolation=ISO_READ_COMMITTED, object=0x7ff2080b4810) at ../../mysql-8.0.17/sql/dd/impl/cache/shared_dictionary_cache.cc:113
#10 0x0000000003f0fa70 in dd::cache::Shared_dictionary_cache::get<dd::Item_name_key, dd::Column_statistics> (this=0x7132e20 <dd::cache::Shared_dictionary_cache::instance()::s_cache>, thd=0x7ff150000c00, key=...,
    element=0x7ff2080b4888) at ../../mysql-8.0.17/sql/dd/impl/cache/shared_dictionary_cache.cc:98
#11 0x0000000003e52fd7 in dd::cache::Dictionary_client::acquire<dd::Item_name_key, dd::Column_statistics> (this=0x7ff150004450, key=..., object=0x7ff2080b48f8, local_committed=0x7ff2080b48f7, local_uncommitted=0x7ff2080b48f6)
    at ../../mysql-8.0.17/sql/dd/impl/cache/dictionary_client.cc:861
#12 0x0000000003e3050b in dd::cache::Dictionary_client::acquire<dd::Column_statistics> (this=0x7ff150004450, object_name="test\037tbl_int\037col1", object=0x7ff2080b49f8)
    at ../../mysql-8.0.17/sql/dd/impl/cache/dictionary_client.cc:1206
#13 0x0000000002fd8e5f in histograms::find_histogram (thd=0x7ff150000c00, schema_name="test", table_name="tbl_int", column_name="col1", histogram=0x7ff2080b4c18) at ../../mysql-8.0.17/sql/histograms/histogram.cc:1285
#14 0x0000000002b9ef04 in read_histograms (thd=0x7ff150000c00, share=0x7ff1501153e8, schema=0x7ff15000ecc0, table_def=0x7ff150169350) at ../../mysql-8.0.17/sql/sql_base.cc:587
#15 0x0000000002b9f939 in get_table_share (thd=0x7ff150000c00, db=0x7ff1501017d8 "test", table_name=0x7ff150101050 "tbl_int", key=0x7ff15010160f "test", key_length=13, open_view=true, open_secondary=false)
    at ../../mysql-8.0.17/sql/sql_base.cc:791
#16 0x0000000002b9fd89 in get_table_share_with_discover (thd=0x7ff150000c00, table_list=0x7ff150101238, key=0x7ff15010160f "test", key_length=13, open_secondary=false, error=0x7ff2080b5204) at ../../mysql-8.0.17/sql/sql_base.cc:862
#17 0x0000000002ba514f in open_table (thd=0x7ff150000c00, table_list=0x7ff150101238, ot_ctx=0x7ff2080b5450) at ../../mysql-8.0.17/sql/sql_base.cc:3169
#18 0x0000000002ba947c in open_and_process_table (thd=0x7ff150000c00, lex=0x7ff150003c40, tables=0x7ff150101238, counter=0x7ff150003c98, prelocking_strategy=0x7ff2080b5568, has_prelocking_list=false, ot_ctx=0x7ff2080b5450)
    at ../../mysql-8.0.17/sql/sql_base.cc:5004
#19 0x0000000002baa897 in open_tables (thd=0x7ff150000c00, start=0x7ff2080b5510, counter=0x7ff150003c98, flags=0, prelocking_strategy=0x7ff2080b5568) at ../../mysql-8.0.17/sql/sql_base.cc:5647
#20 0x0000000002bac121 in open_tables_for_query (thd=0x7ff150000c00, tables=0x7ff150101238, flags=0) at ../../mysql-8.0.17/sql/sql_base.cc:6502
#21 0x0000000002cc57b9 in Sql_cmd_dml::prepare (this=0x7ff1501017e0, thd=0x7ff150000c00) at ../../mysql-8.0.17/sql/sql_select.cc:442
#22 0x0000000002cc60f7 in Sql_cmd_dml::execute (this=0x7ff1501017e0, thd=0x7ff150000c00) at ../../mysql-8.0.17/sql/sql_select.cc:640
#23 0x0000000002c60dc5 in mysql_execute_command (thd=0x7ff150000c00, first_level=true) at ../../mysql-8.0.17/sql/sql_parse.cc:3433
#24 0x0000000002c669e8 in mysql_parse (thd=0x7ff150000c00, parser_state=0x7ff2080b6c30) at ../../mysql-8.0.17/sql/sql_parse.cc:5221
#25 0x0000000002c5c01d in dispatch_command (thd=0x7ff150000c00, com_data=0x7ff2080b7cd0, command=COM_QUERY) at ../../mysql-8.0.17/sql/sql_parse.cc:1755
#26 0x0000000002c5a5b5 in do_command (thd=0x7ff150000c00) at ../../mysql-8.0.17/sql/sql_parse.cc:1270
#27 0x0000000002e11aab in handle_connection (arg=0x7602580) at ../../mysql-8.0.17/sql/conn_handler/connection_handler_per_thread.cc:302
#28 0x00000000047b3694 in pfs_spawn_thread (arg=0x7861830) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854
#29 0x00007ff21e892df5 in start_thread () from /lib64/libpthread.so.0
#30 0x00007ff21cca760d in clone () from /lib64/libc.so.6
(gdb)