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

Unexpected ER_DUP_ENTRY upon GROUP BY query from a table with blob

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Critical
    • Resolution: Unresolved
    • N/A
    • 13.1
    • Server
    • None

    Description

      create table t (a blob);
      insert into t values (0),(0);
       
      select @x := a, count(*) from t group by 1;
       
      drop table t;
      

      bb-blob-monty d2622dfc6f12a4238e073cc89d3928a0ddf29792

      create table t (a blob);
      insert into t values (0),(0);
      select @x := a, count(*) from t group by 1;
      bug.496-94a                              [ fail ]
              Test ended at 2026-05-23 00:29:49
       
      CURRENT_TEST: bug.496-94a
      mysqltest: At line 4: query 'select @x := a, count(*) from t group by 1' failed: ER_DUP_ENTRY (1062): Duplicate entry '0' for key 'group_key'
      

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.