PBMS does not allow renaming tables across databases, even when there are no BLOBs in the table

Bug #416969 reported by Paul McCullagh
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBMS
High
Barry Leslie

Bug Description

PBMS returns the following error:

090821 15:47:45 [Error] pbms_rename_table_with_blobs() Error: PBMS does not support renaming tables across databases.

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 :

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.

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 :

Fixed in revision 139

Changed in pbms:
status: Confirmed → Fix Committed
Revision history for this message
Barry Leslie (barry-leslie) wrote :

The fix is actually in revision 143 not 139.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers