Debian Codegraph @

mysql-test/suite/ndb/r/ndb_show_tables.result

raw
1 #
2 # BUG11758430 NDB_SHOW_TABLES SHOULD REQUIRE A DATABASE WHEN TABLE IS SUPPLIED
3 #
4 CREATE TABLE test.t1 (
5 a int primary key,
6 b int
7 )engine=ndbcluster;
8 # Table exists in user db and db specified in ndb_show_tables command
9 id type state logging database schema name
10 XX OrderedIndex Online No sys def PRIMARY
11
12 # Table doesn't exist in TEST_DB and no db specified in ndb_show_tables command
13 Please specify database name using the -d option. Use option --help for more details.
14
15 CREATE DATABASE TEST_DB;
16 CREATE TABLE TEST_DB.t1 (
17 d int primary key,
18 e int
19 )engine=ndbcluster;
20 # Table exists in TEST_DB and no db specified in ndb_show_tables command
21 id type state logging database schema name
22 XX OrderedIndex Online No sys def PRIMARY
23
24 DROP TABLE test.t1;
25 # Table doesn't exist in user db and db specified in ndb_show_tables command
26 Table t1: not found - 723: No such table existed
27
28 DROP TABLE TEST_DB.t1;
29 # Table doesn't exist in TEST_DB and no db specified in ndb_show_tables command
30 Please specify database name using the -d option. Use option --help for more details.
31
32 DROP DATABASE TEST_DB;
33 #
34 # BUG #24383742 NDB : NDB_SHOW_TABLES MISSING TYPE NAME TEXT FOR SOME TYPES
35 #
36 #
37 # Create fully replicated table which will also create a fully replicated
38 # trigger
39 #
40 create table t1 (
41 id1 int primary key
42 )engine=ndb comment='NDB_TABLE=FULLY_REPLICATED=1,PARTITION_BALANCE=FOR_RA_BY_NODE';
43 # Check that "type" column shows 'HashMap'
44 include/assert_grep.inc [Looking for 'HashMap' in lines starting with a number...]
45 # Check that "type" column shows 'FullyRepTrigger'
46 include/assert_grep.inc [Looking for 'FullyRepTrigger' in lines starting with a number...]
47 drop table t1;
48 #
49 # Check working of --fully-qualified
50 #
51 CREATE TABLE test.t1 (
52 a int primary key,
53 b int
54 )engine=ndbcluster;
55 id type state logging database schema name
56 XX OrderedIndex Online No sys def sys/def/YY/PRIMARY
57
58 DROP TABLE test.t1;