# BUG 11758430
"NDB_SHOW_TABLES SHOULD REQUIRE A DATABASE WHEN TABLE IS SUPPLIED"
CREATE TABLE test.t1 (
a int primary key,
b int
)engine=ndbcluster;
"Table exists in user db and db specified in ndb_show_tables command"
id    type                 state    logging database     schema   name
XX    OrderedIndex         Online   No      sys          def      PRIMARY

NDBT_ProgramExit: 0 - OK

"Table doesn't exist in TEST_DB and no db specified in ndb_show_tables command"
Please specify database name using the -d option. Use option --help for more details.

NDBT_ProgramExit: 1 - Failed

CREATE DATABASE TEST_DB;
CREATE TABLE TEST_DB.t1 (
d int primary key,
e int
)engine=ndbcluster;
"Table exists in TEST_DB and no db specified in ndb_show_tables command"
id    type                 state    logging database     schema   name
XX    OrderedIndex         Online   No      sys          def      PRIMARY

NDBT_ProgramExit: 0 - OK

DROP TABLE test.t1;
"Table doesn't exist in user db and db specified in ndb_show_tables command"
Table t1: not found - 723: No such table existed

NDBT_ProgramExit: 1 - Failed

DROP TABLE TEST_DB.t1;
"Table doesn't exist in TEST_DB and no db specified in ndb_show_tables command"
Please specify database name using the -d option. Use option --help for more details.

NDBT_ProgramExit: 1 - Failed

DROP DATABASE TEST_DB;
create table t1 (
id1 int primary key
)engine=ndb comment='NDB_TABLE=FULLY_REPLICATED=1,PARTITION_BALANCE=FOR_RA_BY_NODE';
create temporary table if not exists ndb_show_tables_results (
id int,
type varchar(20),
state varchar(20),
logging varchar(20),
_database varchar(255),
_schema varchar(20),
name varchar(255)
);

ndb_show_tables completed.....

select type from ndb_show_tables_results
where type like '%HashMap%'
limit 1;
type
'HashMap'
select type from ndb_show_tables_results
where type like '%FullyRepTrigger%'
limit 1;
type
'FullyRepTrigger'
drop table t1,ndb_show_tables_results;
CREATE TABLE test.t1 (
a int primary key,
b int
)engine=ndbcluster;
id    type                 state    logging database     schema   name
XX    OrderedIndex         Online   No      sys          def      sys/def/YY/PRIMARY

NDBT_ProgramExit: 0 - OK

DROP TABLE test.t1;