[MDEV-8027] Truncate on InnoDB with foreign key does not delete one after another - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL)
Fix Version/s: N/A
Component/s: Documentation, Storage Engine - InnoDB
Labels:
- foreign-keys
- innodb
- truncate
- verified
Environment:
Debian Linux x64

Description

According to the documentation (https://mariadb.com/kb/en/mariadb/truncate-table/) a truncate on a table with InnoDB should empty the table by deleting the table and recreating it. If the table contains foreign keys the engine should delete row after row and trigger all foreign keys. But thats currently not the case. Currently mariadb fails with the error:

ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint

Thanks and greetings
Leo

Attachments

Activity

People

Assignee:: Ian Gilfillan

Reporter:: Leo Unglaub

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2015-04-20 17:50

Updated:: 2015-04-24 09:15

Resolved:: 2015-04-22 10:29

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.