Bug #3746 SHOW TABLE does not autodiscover tables

• Submitted: 13 May 2004 16:23
• Modified: 5 Oct 2004 11:06
• Reporter: Johan Andersson
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S4 (Feature request)
• Version: mysql 4.1.2 - ndb 3.5.0 - alpha
• OS: Linux (rh 7.3)
• Assigned to: Magnus Blåudd
• CPU Architecture: Any

[13 May 2004 16:23] Johan Andersson

Description:
2 mysql servers (denoted A and B) 
1 ndbcluster

1. create table in A
2. on B: show table.

table does not show up. I think ndb_discover_tables should run on show tables;

How to repeat:
On A:   use test; create table t1(a integer primary key, b integer) type=ndb;
On B:   use test; show tables;

Suggested fix:
ndb_discover_tables should be executed when show tables is executed.

[13 May 2004 16:25] Johan Andersson

added version

[13 May 2004 16:49] Magnus Blåudd

See WL#1424

As a workaround use "SELECT * FROM t1 LIMIT 1" on B.

[30 Sep 2004 15:19] Magnus Blåudd

Pushed to mysql-4.1-ndb.

[5 Oct 2004 11:06] Magnus Blåudd

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html