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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Comment |
[ It seems to be that
mysqld Ver 10.2.32-MariaDB-1:10.2.32+maria~bionic for debian-linux-gnu on x86_64 (mariadb.org binary distribution) is unaffected. Also mysql does not seem to have the same problem. ] |
| Link |
This issue relates to |
| Assignee | Alexander Barkov [ bar ] |
| Description |
This issue is a little bit similar to https://jira.mariadb.org/browse/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. |
This issue is a little bit similar to 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. |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Assignee | Alexander Barkov [ bar ] | Oleksandr Byelkin [ sanja ] |
| Workflow | MariaDB v3 [ 110139 ] | MariaDB v4 [ 142023 ] |
| Affects Version/s | 10.8.3 [ 27502 ] | |
| Affects Version/s | 10.6.7 [ 26812 ] |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Fix Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.4 [ 22408 ] |