Show tables statement support name like syntax

[jiacai2050]

Description

Currently, show tables is supported by CeresDB, it would be convenient to support name like syntax like in MySQL.

SHOW TABLES LIKE 'pattern'

Proposal

Support this syntax with reference with MySQL

Additional context

Currently it will return error below

• https://github.com/CeresDB/ceresdb/blob/334bc6ce13aac2e72a0771419b4aefe2164255e9/tests/cases/01_system/system_tables.result#L15

ref #154

[QuintinTao]

hi， I wonder that we need to support "SHOW TABLES LIKE 'pattern'" or "SHOW TABLES name LIKE '01_system_table1'"?
Is the name esential?

[jiacai2050]

• https://dev.mysql.com/doc/refman/8.0/en/show-tables.html

SHOW TABLES LIKE 'pattern'

This style is preferred.

[QuintinTao]

Thanks I want to try it.

[jiacai2050]

Thanks, go ahead.

Feel free to ask questions if you have any problems.

• https://join.slack.com/t/ceresdbcommunity/shared_invite/zt-1dcbv8yq8-Fv8aVUb6ODTL7kxbzs9fnA

[jiacai2050]

There are two special chars in pattern

• _ to match any single character and
• % to match an arbitrary number of characters (including zero characters).

We can replace _ to . and % to .* to match regex syntax.

[QuintinTao]

There are two special chars in pattern

• _ to match any single character and
• % to match an arbitrary number of characters (including zero characters).

We can replace _ to . and % to .* to match regex syntax.

OK