[MDEV-30871] UDF return value character set bug Created: 2023-03-17  Updated: 2023-03-17

Status: Open
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.11.1, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mitchell Lee Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Any


 Description   

UDF string type return value recognized as Binary. Not string.
MySQL fixed three years ago. Need to fix.

Related conversation 1:
https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/UDF's.20string.20return.20won't.20be.20recognized.20as.20char.20but.20binary.2E

Related conversation 2:
https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/With.20nested.20query.2C.20UDF's.20result.20disappeared

And
The SOLUTION brief from brilliant mysql guys at below:
https://dev.mysql.com/blog-archive/a-tale-of-udfs-with-character-sets/

 Comments   
Comment by Sergei Golubchik [ 2023-03-17 ]

please, add some info to https://mariadb.com/kb/en/mariadb-internals-documentation/
about data type and function plugins.

greenman FYI.

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