XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 1.1.4
    • Icebox
    • DMLProc
    • None
    • [root@server87 ~]# cat /etc/redhat-release
      CentOS release 6.9 (Final)

    Description

      Hi, Team!!

      There is a problem in the condition processing of Where and under when deleting the data in the column store table.

      MariaDB [edw]> create table t_main (id int, nm varchar(10)) engine=columnstore;
      Query OK, 0 rows affected (2.39 sec)
      MariaDB [edw]>
      MariaDB [edw]> create table t_sub (id int, nm varchar(10)) engine=columnstore;
      Query OK, 0 rows affected (1.50 sec)

      MariaDB [edw]> insert into t_main values(1,'AAA');
      Query OK, 1 row affected (0.49 sec)

      MariaDB [edw]> insert into t_main values(2, 'BBB');
      Query OK, 1 row affected (0.24 sec)

      MariaDB [edw]> insert into t_sub values(1,'CCC');
      Query OK, 1 row affected (0.36 sec)

      MariaDB [edw]> delete from t_main
      -> where id in (select id from t_sub)
      -> and 1=0;
      Query OK, 0 rows affected (0.01 sec)

      MariaDB [edw]> select * from t_main;
      ----------+

      id nm

      ----------+

      1 AAA
      2 BBB

      ----------+
      2 rows in set (0.16 sec)

      MariaDB [edw]> delete from t_main
      -> where id in (select id from t_sub)
      -> and 0=0;
      Query OK, 2 rows affected (0.34 sec)

      MariaDB [edw]> select * from t_main;
      Empty set (0.03 sec)

      MariaDB [edw]>OMG~~

      Attachments

        Activity

          People

            drrtuy Roman
            ossk_db ossk_db
            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.