Bug #93607 'COM_FIELD_LIST' is deprecated warning after use dbname
Submitted: 14 Dec 2018 8:44 Modified: 14 Dec 2018 9:00
Reporter: Nikolai Ikhalainen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version:5.7.24, 8.0.13 OS:Any
Assigned to: CPU Architecture:Any

[14 Dec 2018 8:44] Nikolai Ikhalainen
Description:
mysql cli shows warning on database change with use command. (Unless  --skip-auto-rehash option is provided).

How to repeat:
docker run -d --name=mysql1 -e MYSQL_ALLOW_EMPTY_PASSWORD=1 mysql:latest
docker exec -i mysql1 mysql -e 'create database test;create table test.t(id int);'
docker exec -it mysql1 mysql
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show warnings\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1287
Message: 'COM_FIELD_LIST' is deprecated and will be removed in a future release. Please use SHOW COLUMNS FROM statement instead
1 row in set (0.00 sec)
[14 Dec 2018 9:00] MySQL Verification Team
Hello Nikolai,

Thank you for the report.
Verified as described.

regards,
Umesh
[28 Jul 2021 23:11] Jean-François Gagné
Related: Bug#103535.