SHOW TABLE STATUS support in Site Health

[dd32]

While support for SHOW TABLE STATUS was added in #77 it appears that the expression must be followed by a filter or a ;.

WordPress makes this query without a ; and without any conditional filtering.

https://github.com/WordPress/wordpress-develop/blob/a788083247e256f48d9cc16941b3ede10b6b7ea6/src/wp-admin/includes/class-wp-debug-data.php#L1847

This was noticed via https://core.trac.wordpress.org/ticket/63058 (This doesn't cause the entirety of that ticket)

Implementation:

sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-translator.php

Lines 3537 to 3553 in 271163b

	case 'TABLE STATUS': // FROM `database`.
	// Match the optional [{FROM | IN} db_name].
	$database_expression = $this->rewriter->consume();
	if ( 'FROM' === $database_expression->token || 'IN' === $database_expression->token ) {
	$this->rewriter->consume();
	$database_expression = $this->rewriter->consume();
	}
	$pattern = '%';
	// [LIKE 'pattern' | WHERE expr]
	if ( 'LIKE' === $database_expression->token ) {
	$pattern = $this->rewriter->consume()->value;
	} elseif ( 'WHERE' === $database_expression->token ) {
	// @TODO Support me please.
	} elseif ( ';' !== $database_expression->token ) {
	throw new Exception( 'Syntax error: Unexpected token ' . $database_expression->token . ' in query ' . $this->mysql_query );
	}

Testing with WP Console in Playground verifies this behaviour, a DB error is visible within the browser console:

[02-May-2025 01:56:54 UTC] WordPress database error <div style="clear:both">&nbsp;</div>
<div class="queries" style="clear:both;margin-bottom:2px;border:red dotted thin;">
<p>MySQL query:</p>
<p>SHOW TABLE STATUS</p>
<p>Queries made or created this session were:</p>
<ol>
<li>Executing: BEGIN | (no parameters)</li>
<li>Executing: ROLLBACK | (no parameters)</li>
</ol>
</div>
<div style="clear:both;margin-bottom:2px;border:red dotted thin;" class="error_message" style="border-bottom:dotted blue thin;">
Error occurred at line 4164 in Function <code>handle_error</code>. Error message was: Syntax error: Unexpected token  in query SHOW TABLE STATUS.
</div>
<p>Backtrace:</p>
<pre>#0 /internal/shared/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(287): WP_SQLite_Translator->get_error_message()
#1 /wordpress/wp-includes/class-wpdb.php(4): WP_SQLite_DB->query('SHOW TABLE STAT...')
#2 /wordpress/wp-content/plugins/wp-console/includes/Core/Console/RestController.php(139) : eval()'d code(3): wpdb->get_results('SHOW TABLE STAT...', 'ARRAY_A')
#3 /wordpress/wp-content/plugins/wp-console/includes/Core/Console/RestController.php(139): eval()
#4 /wordpress/wp-includes/rest-api/class-wp-rest-server.php(3): WPConsole\Core\Console\RestController->create_item(Object(WP_REST_Request))
#5 /wordpress/wp-includes/rest-api/class-wp-rest-server.php(3): WP_REST_Server->respond_to_request(Object(WP_REST_Request), '/wp-console/v1/...', Array, NULL)
#6 /wordpress/wp-includes/rest-api/class-wp-rest-server.php(3): WP_REST_Server->dispatch(Object(WP_REST_Request))
#7 /wordpress/wp-includes/rest-api.php(2): WP_REST_Server->serve_request('/wp-console/v1/...')
#8 /wordpress/wp-includes/class-wp-hook.php(3): rest_api_loaded(Object(WP))
#9 /wordpress/wp-includes/class-wp-hook.php(3): WP_Hook->apply_filters('', Array)
#10 /wordpress/wp-includes/plugin.php(2): WP_Hook->do_action(Array)
#11 /wordpress/wp-includes/class-wp.php(3): do_action_ref_array('parse_request', Array)
#12 /wordpress/wp-includes/class-wp.php(3): WP->parse_request('')
#13 /wordpress/wp-includes/functions.php(2): WP->main('')
#14 /wordpress/wp-blog-header.php(2): wp()
#15 /wordpress/index.php(2): require('/wordpress/wp-b...')
#16 {main}</pre>
 for query SHOW TABLE STATUS made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPConsole\Core\Console\RestController->create_item, eval, WP_SQLite_DB->query, WP_SQLite_DB->print_error

[dd32]

Additionally, this does kinda cause https://core.trac.wordpress.org/ticket/63058 but not the same issue, the issue being that the command doesn't return the table sizes (always 0 bytes).