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

Bug after upgrade to 10.1.10

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 5.5, 10.0, 10.1
    • Fix Version/s: 10.1.11
    • Component/s: Optimizer
    • Labels:
    • Environment:
      Centos 7 x86_64
    • Sprint:
      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

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              ampf Antonio Fernandes
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration