Some MySQL administrative queries return empty results

[bbkr]

Some MySQL administrative queries return empty results

[bbkr]

I found weird workaround:

$database.execute( 'SHOW CREATE TABLE foo' ).allrows().say;

is not working (returning Empty list), but wrapping it in server side prepared statement works just fine:

$database.execute( 'PREPARE foo FROM "SHOW CREATE TABLE foo"' );
$database.execute( 'EXECUTE foo' ).allrows().say;

:)

[bbkr]

I wonder if this is caused by returned data type. Everything that returns information_schema columns directly (like SHOW TABLES) works, everything that is somehow concatenating various information schema info (like SHOW CREATE TABLE foo) does not.