[#MDEV-32378] concat_ws result with big strings

[MDEV-32378] concat_ws result with big strings Created: 2023-10-09 Updated: 2023-10-09 Resolved: 2023-10-09
Status:	Closed
Project:	MariaDB Server
Component/s:	Documentation
Affects Version/s:	10.6.15
Fix Version/s:	N/A

Type:

Bug

Priority:

Minor

Reporter:

bulepage

Assignee:

Unassigned

Resolution:

Not a Bug

Votes:

Labels:

None

Description

select LENGTH(

CONCAT_WS('',

LPAD('',485761,'-'),

LPAD('',2000000,'-'),

LPAD('',2000000,'-'),

LPAD('',2000000,'-'),

LPAD('',2000000,'-'),

LPAD('',2000000,'-')

);

result is null, but in documentation no limit. Please update documentation!
Same problem with lpad Please update documentation!

select length(LPAD('',3000000,'-'));

return with null

Comments

Comment by Sergei Golubchik [ 2023-10-09 ]

may be it's max_allowed_packet limit?

Maximum size in bytes of a packet or a generated/intermediate string

Comment by bulepage [ 2023-10-09 ]

Yes in my server is @@max_allowed_packet=10485760

Generated at Thu Feb 08 10:30:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.