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

• Submitted: 23 Sep 2020 20:34
• Modified: 1 Oct 2020 17:36
• Reporter: Agustín G
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• CPU Architecture: Any
• Tags: documentation

[23 Sep 2020 20:34] Agustín G

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.

[23 Sep 2020 22:18] MySQL Verification Team

Thank you for the bug report.

[24 Sep 2020 9:34] Stefan Hinz

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

[1 Oct 2020 17:36] Agustín G

Awesome. Thanks a lot!