Bug #100930 Missing quotes in query for checking state of undo tablespace

Description:
For https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html#truncate-undo-tablesp...

The following query is missing quotes:

SELECT NAME, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
  WHERE NAME LIKE tablespace_name;

How to repeat:
mysql [localhost:24249] {msandbox} (test) > SELECT NAME, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES   WHERE NAME LIKE innodb_undo_001;
ERROR 1054 (42S22): Unknown column 'innodb_undo_001' in 'where clause'

Suggested fix:
Use the following query instead:

SELECT NAME, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
  WHERE NAME LIKE 'tablespace_name';

mysql [localhost:24249] {msandbox} (test) > SELECT NAME, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES   WHERE NAME LIKE 'innodb_undo_001';
+-----------------+--------+
| NAME            | STATE  |
+-----------------+--------+
| innodb_undo_001 | active |
+-----------------+--------+
1 row in set (0.01 sec)

It may also be good to be explicit about <tablespace_name> being an actual placeholder for innodb_undo_00x, etc.

Thank you for the bug report.

Posted by developer:
 
Fixed. (Will take a little while to show up online.) Thanks for reporting!

Awesome. Thanks a lot!