Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15136

'delete from user where username = "admin"' failed: 1112: Table 'user' uses an extension that doesn't exist in this MariaDB version

    Details

      Description

      create table user
      (
          id               int auto_increment primary key,
          username         varchar(50) not null
      ) engine innodb 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
      ) engine innodb with system versioning;
       
       
      insert into user(username) values ("admin");
       
      insert into products(name, modifiedby) values ("apple", 1);
      delete from user where username = "admin";
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                kevg Eugene Kosov
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: