Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 10.0.14
-
Fix Version/s: N/A
-
Component/s: Storage Engine - Connect
-
Labels:
Description
In this page:
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?
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Closing as can't repeat
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.