[MDEV-7119] CONNECT and ALTER TABLE: real behavior != documentation Created: 2014-11-15  Updated: 2015-02-02  Resolved: 2015-02-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.0.14
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Federico Razzoli Assignee: Ian Gilfillan
Resolution: Cannot Reproduce Votes: 0
Labels: documentation


 Description   

In this page:

https://mariadb.com/kb/en/mariadb/documentation/storage-engines/connect/connect-table-types/inward-and-outward-tables/

I read:

"Translating a CONNECT table to another engine is fine but the opposite is forbidden when the target CONNECT table is not table based or when its data file exists"

I tried ALTER TABLE ... ENGINE = ? in both directions (from and to CONNECT) with both file-based inward/outward tables. It always works: no errors, data is not damaged.

Maybe the documentation is not updated?



 Comments   
Comment by Ian Gilfillan [ 2014-11-20 ]

Can you give an example of this? When I try this, for example to ALTER an Aria table to CONNECT when the data file exists, I get "ERROR 1105 (HY000): Operation denied. Table data would be lost." which is the expected, documented behaviour.

Comment by Ian Gilfillan [ 2015-02-02 ]

Closing as can't repeat

Generated at Thu Feb 08 07:17:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.