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

Data Truncation when using UNION SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.23, 10.4.13, 10.6.7, 10.8.3
    • 10.4, 10.5
    • Data types
    • None
    • Linux

    Description

      This issue is a little bit similar to MDEV-17226

      When selecting a large number of string characters witih an UNION the data gets truncated.
      I did not found any variable which can change this behaviour and I did not get any answers on my stackoverflow question regarding this:
      https://stackoverflow.com/questions/62404168/mariadb-cuts-of-text-when-select-with-union

      Example is attached.
      Simple example:
      SELECT 'LARGETEXT' works fine.
      SELECT 'SHORTTEXT' UNION SELECT 'LARGETEXT' truncated the text after about 34797 Bytes.
      The order of the columns does not make any difference. So also
      SELECT 'LARGETEXT' UNION SELECT 'SHORTTEXT'
      does fail.

      This seems to be critical for me because the user is not noticed about loss of data.

      Attachments

        1. mariabug.txt
          294 kB
          Thomas Christlieb

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              ThomasChr Thomas Christlieb
              Votes:
              4 Vote for this issue
              Watchers:
              8 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.