Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.4
-
None
-
Windows 10 64Bit; Ubuntu 17.10 64Bit
Description
I was testing out the new system-versioned tables and stumbled upon the ER_UNSUPPORTED_EXTENSION
when using ON DELETE CASCADE in my table definition.
DROP DATABASE IF EXISTS test;
|
CREATE DATABASE test;
|
USE test;
|
|
CREATE TABLE User
|
(
|
Id INT AUTO_INCREMENT PRIMARY KEY,
|
Username VARCHAR(50) NOT NULL
|
) WITH SYSTEM VERSIONING;
|
|
|
CREATE TABLE Products
|
(
|
Id INT AUTO_INCREMENT PRIMARY KEY,
|
Name VARCHAR(100) NOT NULL,
|
ModifiedBy INT NOT NULL,
|
FOREIGN KEY(ModifiedBy) REFERENCES User(Id) ON DELETE CASCADE
|
) WITH SYSTEM VERSIONING;
|
|
|
INSERT INTO User(Username) VALUES ("admin");
|
|
INSERT INTO Products(Name, ModifiedBy) VALUES ("Apple", 1);
|
#Error is thrown on the delete
|
DELETE FROM User WHERE Username = "admin";
|
Attachments
Issue Links
- relates to
-
MDEV-15136 'delete from user where username = "admin"' failed: 1112: Table 'user' uses an extension that doesn't exist in this MariaDB version
- Closed
-
MDEV-14681 Bogus ER_UNSUPPORTED_EXTENSION (Table uses an extension that doesn't exist in this MariaDB version)
- Closed