78 lines
2.2 KiB
Plaintext
78 lines
2.2 KiB
Plaintext
# 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;
|