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

Incorrect 0 row(s) affected on delete

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.2
    • 1.1.4
    • MariaDB Server
    • None
    • -- version=10.2.10-MariaDB-log
      -- version_comment=Columnstore 1.1.2-1
    • 2018-03, 2018-04, 2018-05, 2018-06

    Description

      when I was doing some tests I observed that when I delete a row (via a join to another column store table) the server reports 0 rows affected even when row is deleted.

      Here's a sample...

      – version=10.2.10-MariaDB-log
      – version_comment=Columnstore 1.1.2-1

      CREATE TABLE cs1 (
      id INT(10) UNSIGNED NOT NULL,
      `timestamp_` DATETIME,
      numeric_val DOUBLE DEFAULT NULL
      ) ENGINE=columnstore;
      INSERT INTO cs1 VALUES (1, '2018-01-09 21:59:02', 11.11)

      CREATE TABLE cs2 (
      id INT(10) UNSIGNED NOT NULL,
      `timestamp_` DATETIME,
      numeric_val DOUBLE DEFAULT NULL
      ) ENGINE=columnstore;

      INSERT INTO cs2 VALUES (1, '2018-01-09 21:59:02', 22.22);

      SELECT * FROM cs1;
      DELETE FROM cs1 WHERE id = 1;
      – correctly reporting rows affected
      – Query: delete from cs1 where id = 1
      – 1 row(s) affected
      SELECT * FROM cs1;
      – Query: select * from cs1 LIMIT 0, 5000
      – 0 row(s) affected

      INSERT INTO cs1 VALUES (1, '2018-01-09 21:59:02', 11.11);

      SELECT * FROM cs1;
      SELECT * FROM cs2;
      DELETE cs1 FROM cs1
      JOIN cs2 USING(id,timestamp_);
      – reporting 0 rows affected when 1 row was affected
      – Query: DELETE cs1 from cs1 join cs2 using(id,timestamp_)
      – 0 row(s) affected

      SELECT * FROM cs1;
      – Query: SELECT * FROM cs1 LIMIT 0, 5000
      – 0 row(s) affected

      SELECT * FROM cs2;
      – Query: SELECT * FROM cs2 LIMIT 0, 5000
      – 1 row(s) affected

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              thebreadguru MIke Thibodeau
              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.