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

    XMLWordPrintable

    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: