# # BUG11758430 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 # 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. 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 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 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. DROP DATABASE TEST_DB; # # BUG #24383742 NDB : NDB_SHOW_TABLES MISSING TYPE NAME TEXT FOR SOME TYPES # # # Create fully replicated table which will also create a fully replicated # trigger # create table t1 ( id1 int primary key )engine=ndb comment='NDB_TABLE=FULLY_REPLICATED=1,PARTITION_BALANCE=FOR_RA_BY_NODE'; # Check that "type" column shows 'HashMap' include/assert_grep.inc [Looking for 'HashMap' in lines starting with a number...] # Check that "type" column shows 'FullyRepTrigger' include/assert_grep.inc [Looking for 'FullyRepTrigger' in lines starting with a number...] drop table t1; # # Check working of --fully-qualified # 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 DROP TABLE test.t1;