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

              serg Sergei Golubchik
              kevg Eugene Kosov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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