Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9332

Bug after upgrade to 10.1.10

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.3.12, 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.1.11
    • Optimizer
    • Centos 7 x86_64
    • 10.1.11

    Description

      After I've updated my replication slave to 10.1.10 i've begun having replication problems with a query I've narrow down to a MySQL bug (https://bugs.mysql.com/bug.php?id=58081). Is this a bug?

      set names latin1;
      		 
      drop table if exists t1;
      		 
      create table t1(a int) engine=myisam;
      		 
      insert into t1 values (0),(0),(1),(0),(0);
      		 
      select count(*) from t1, t1 t2 group by insert('', t2.a, t1.a,(@@global.max_binlog_size));
      		 
      /* SQL Error (1062): Duplicate entry '107374182410737418241' for key 'group_key' */
      		 
      /* Affected rows: 5  Found rows: 0  Warnings: 1  Duration for 4 of 5 queries: 0,188 sec. */

      Attachments

        Issue Links

          is part of

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9500 Bug after upgrade to 10.1.10 (and 10.1.11)

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Bug #58081 Duplicate entry error when doing GROUP BY

          Activity

            People

              bar Alexander Barkov
              ampf Antonio Fernandes
              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.