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

GROUP_CONCAT incomplete, not near group_concat_max_len.

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.5.13, 10.3.36, 10.5.17
    • 10.4, 10.5, 10.6
    • Data types
    • None

    Description

      See below. The GROUP_CONCAT is missing the last two characters.

      +---------------------------------------+
      | VERSION()                             |
      +---------------------------------------+
      | 10.5.13-MariaDB-1:10.5.13+maria~focal |
      +---------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> select GROUP_CONCAT(a) FROM (SELECT CONCAT(conv('38681F000', 16, 10) / conv('38681F400', 16, 10) * 100 - 100, 'AFTER') as a) xxx;
      +------------------------------+
      | GROUP_CONCAT(a)              |
      +------------------------------+
      | -0.0000067628410249653825AFT |
      +------------------------------+
      1 row in set (0.000 sec)
      

      Just the CONCAT is fine:

      MariaDB [(none)]> SELECT CONCAT(conv('38681F000', 16, 10) / conv('38681F400', 16, 10) * 100 - 100, 'AFTER');
      +------------------------------------------------------------------------------------+
      | CONCAT(conv('38681F000', 16, 10) / conv('38681F400', 16, 10) * 100 - 100, 'AFTER') |
      +------------------------------------------------------------------------------------+
      | -0.0000067628410249653825AFTER                                                     |
      +------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
      

      This was initially hit with real data in column type float, but above is same issue with no need for the table. The conv() is needed to get original float values. Just selecting them the two print the same.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bexamous Brian
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.