Bug #5171 Multi-database queries with BLOBs do not work
Submitted: 23 Aug 2004 17:14 Modified: 23 Aug 2004 20:53
Reporter: Martin Skold Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version: OS:
Assigned to: Martin Skold CPU Architecture:Any

[23 Aug 2004 17:14] Martin Skold 
Description:
BLOB tables are resolved by name at access point
instead of at table create/open. This causes BLOB
tables not top be found if the database has been
switched.

How to repeat:
create table t1 (
  a int not null primary key,
  b text not null,
  c int not null,
  d longblob,
  key (c)
) engine=ndbcluster;

create database test2;
use test2;

CREATE TABLE t2 (
  a bigint unsigned NOT NULL PRIMARY KEY,
  b int unsigned not null,
  c int unsigned
) engine=ndbcluster;

...
select * from test.t1,t2 where test.t1.a = t2.a order by a;

Suggested fix:
Save a table reference as part of the meta-data for
each BLOB column.
[23 Aug 2004 20:53] Martin Skold 
Patch pushed to 4.1