Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.23, 10.4.13, 10.6.7, 10.8.3
-
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
Issue Links
- relates to
-
MDEV-17226 Column Data in Truncated on UNION to the length of the first value if using REPLACE
- Closed