Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6361

mcs10_drop_db_table, mcs89_drop_table_restrict MTRs fail

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • None
    • N/A
    • Tests
    • None
    • RHEL-like distros

    Description

      A non-existing table can be deleted.

      Manual check:

      MariaDB [x]> CREATE TABLE t1 (id INT, name CHAR(25));
      Query OK, 0 rows affected (0.012 sec)
       
      MariaDB [x]> INSERT INTO t1 VALUES (1, 'one'), (2, 'two'), (3, 'three'), (4, 'four'), (5, 'five');
      Query OK, 5 rows affected (0.001 sec)
      Records: 5  Duplicates: 0  Warnings: 0
       
      MariaDB [x]> DROP TABLE IF EXISTS t1 RESTRICT;
      Query OK, 0 rows affected (0.006 sec)
       
      MariaDB [x]> DROP TABLE t1;
      Query OK, 0 rows affected (0.004 sec)
       
      MariaDB [x]> DROP TABLE t1;
      Query OK, 0 rows affected (0.003 sec)
       
      MariaDB [x]> show tables;
      Empty set (0.000 sec)
       
      MariaDB [x]> DROP TABLE t1;
      Query OK, 0 rows affected (0.003 sec)
      
      

      even shorter test:

      MariaDB [x]> create database y;
      Query OK, 1 row affected (0.000 sec)
       
      MariaDB [x]> drop table t;
      Query OK, 0 rows affected (0.003 sec)
      
      

      Attachments

        Issue Links

          Activity

            People

              sergey.zefirov Sergey Zefirov
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.