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
 
 -