PBMS does not allow renaming tables across databases, even when there are no BLOBs in the table
Bug #416969 reported by
Paul McCullagh
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| PBMS |
Fix Committed
|
High
|
Barry Leslie | ||
Bug Description
PBMS returns the following error:
090821 15:47:45 [Error] pbms_rename_
When executing the following commands:
use test;
create database mysqltest;
create table t1 (c1 int);
alter table t1 rename mysqltest.t1;
Although this may be a valid limitation of PBMS for tables containing BLOBs, I think that PBMS should ignore (basically allow) the rename if, there are no BLOBs in the table t1.
Revision history for this message
| Barry Leslie (barry-leslie) wrote | #1 |
| Changed in pbms: | |
| assignee: | nobody → Barry Leslie (barry-leslie) |
| importance: | Undecided → High |
| status: | New → Confirmed |
Revision history for this message
| Barry Leslie (barry-leslie) wrote | #2 |
| Changed in pbms: | |
| status: | Confirmed → Fix Committed |
Revision history for this message
| Barry Leslie (barry-leslie) wrote | #3 |
To post a comment you must log in.
The fix for this is not to check for cross database renaming of tables in the glue code. If PBMS can not handle it, then the PBMS engine will report an error.