Bug #30667 ndb table discovery does not work correcly with information schema
Submitted: 28 Aug 2007 12:39 Modified: 15 Sep 2007 11:14
Reporter: Tomas Ulin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Tomas Ulin CPU Architecture:Any

[28 Aug 2007 12:39] Tomas Ulin 
Description:
create table t1
take backup
drop table t1
restore using ndb_restore
master> select * from information_schema.columns where table_name = "t1";
Empty set, 1 warning (0.00 sec)

master> show warnings;
+---------+------+---------------------------------------+
| Level   | Code | Message                               |
+---------+------+---------------------------------------+
| Warning | 1050 | Local table test.t1 shadows ndb table | 
+---------+------+---------------------------------------+
1 row in set (0.00 sec)

How to repeat:
.

Suggested fix:
workaround exists by doing show tables or similar
[28 Aug 2007 13:35] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33217

ChangeSet@1.2583, 2007-08-28 15:43:06+02:00, tomas@whalegate.ndb.mysql.com +2 -0
  Bug #30667 ndb table discovery does not work correcly with information schema
  - the listed file_names are not necessarily on disk, so we need to discover them if they aren't
[28 Aug 2007 13:37] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33219

ChangeSet@1.2584, 2007-08-28 15:44:20+02:00, tomas@whalegate.ndb.mysql.com +1 -0
  Bug #30667 result file
[7 Sep 2007 20:08] Jon Stephens 
Documented bugfix in mysql-5.1.22-ndb-6.2.5 changelog; left status as PP, waiting for merge with 5.1-main.
[14 Sep 2007 16:26] Bugs System 
Pushed into 5.1.23-beta
[15 Sep 2007 11:14] Jon Stephens 
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Also documented in 5.1.23 changelog.