sql: SHOW PARTITIONS FROM TABLE doesn't work across databases

[solongordon]

SHOW PARTITIONS FROM TABLE doesn't appear to work unless the table's database is the currently used database.

root@127.0.0.1:61370/movr> create database d;
CREATE DATABASE

root@127.0.0.1:61370/movr> create table d.t (x int primary key) partition by list (x) (partition p values
in (1));
CREATE TABLE

root@127.0.0.1:61370/movr> show partitions from table d.t;
  database_name | table_name | partition_name | parent_partition | column_names | index_name | partition_value | zone_config
+---------------+------------+----------------+------------------+--------------+------------+-----------------+-------------+
(0 rows)

root@127.0.0.1:61370/movr> use d;
SET

root@127.0.0.1:61370/d> show partitions from table d.t;
  database_name | table_name | partition_name | parent_partition | column_names | index_name | partition_value | zone_config
+---------------+------------+----------------+------------------+--------------+------------+-----------------+-------------+
  d             | t          | p              | NULL             | x            | t@primary  | (1)             | NULL
(1 row)

[awoods187]

good find! we should fix this for 19.2 to make sure it's usable for customers