SQL: Consistency between LIKE pattern and table pattern #33294
Description
Through #33278, the tableIdentifier has been extended to allow ES-like multi-index patterns. However this is not supported by all commands, such as SHOW TABLES which only allow SQL LIKE pattern.
Both should be supported across the board for consistency and also capabilities so :
SHOW TABLES LIKE "foo%" and SHOW TABLES 'foo*,-foobar* work.
(note that while SQL LIKE only allows inclusion, ES allows exclusion also).